SharePoint Calculated Column

%3CLINGO-SUB%20id%3D%22lingo-sub-1030524%22%20slang%3D%22en-US%22%3ESharePoint%20Calculated%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1030524%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20recently%20migrated%20a%20on-prem%20sharepoint%20list%20to%20SharePoint%20online.%26nbsp%3B%20The%20list%20has%20calculated%20columns%20that%20uses%20html%20to%20show%20a%20Red%2FGreen%2FYellow%20icons%20depending%20on%20an%20IF%20statement.%26nbsp%3B%20I'm%20very%20new%20to%20Json%2C%20and%20trying%20to%20figure%20out%20how%20to%20format%20the%20column%20using%20images%20saved%20in%20the%20graphics%20library.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20greatly%20appreciated.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1030524%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1032455%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Calculated%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1032455%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F77625%22%20target%3D%22_blank%22%3E%40Kim%20Williams%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20a%20great%20article%20that%20will%20take%20you%20through%20formatting%20columns.%3C%2FP%3E%3CP%3ECheck%20this%20one%20out%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fdeclarative-customization%2Fcolumn-formatting%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fdeclarative-customization%2Fcolumn-formatting%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

I've recently migrated a on-prem sharepoint list to SharePoint online.  The list has calculated columns that uses html to show a Red/Green/Yellow icons depending on an IF statement.  I'm very new to Json, and trying to figure out how to format the column using images saved in the graphics library.

 

Any help would be greatly appreciated.  

1 Reply

Hi @Kim Williams ,

 

There is a great article that will take you through formatting columns.

Check this one out

https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting