SP list formatting with JSON how to..

%3CLINGO-SUB%20id%3D%22lingo-sub-2438598%22%20slang%3D%22en-US%22%3ESP%20list%20formatting%20with%20JSON%20how%20to..%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2438598%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20where%20to%20post..%20can%20I%20ask%20about%20SP%20list%20formatting%20here%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20column%20status%20-%20in%20progress%2C%20completed%2C%20need%20action%20%2C%26nbsp%3B%20contract%20-%26nbsp%3B%20%26nbsp%3BI%20need%20it%20to%20auto%20fill%20the%20status%20when%3C%2FP%3E%3CP%3EContractDate%20has%20date%20in%20-%20Contract%3C%2FP%3E%3CP%3EWorkAmt%20has%20number%20-%20InProgess%3C%2FP%3E%3CP%3EPaidAmt%20-%20has%20number%20-%20Completed%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20provide%20the%20JSON%20Code%20%3F%3F%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2438598%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-2439152%22%20slang%3D%22en-US%22%3ERe%3A%20SP%20list%20formatting%20with%20JSON%20how%20to..%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2439152%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F612792%22%20target%3D%22_blank%22%3E%40bbsin%3C%2FA%3E%26nbsp%3BWith%20limited%20info%20here%2C%20I%20guess%20this%20might%20help%20you%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fdeclarative-customization%2Fcolumn-formatting%23apply-formatting-based-on-date-ranges%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fdeclarative-customization%2Fcolumn-formatting%23apply-formatting-based-on-date-ranges%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20has%20the%20similar%20example%2C%20where%20in%20condition%20is%20being%20matched%20for%20another%20field.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi

 

Not sure where to post.. can I ask about SP list formatting here?

 

I have a column status - in progress, completed, need action ,  contract -   I need it to auto fill the status when

ContractDate has date in - Contract

WorkAmt has number - InProgess

PaidAmt - has number - Completed

 

 

Can someone provide the JSON Code ?? Thanks

1 Reply

@bbsin With limited info here, I guess this might help you - 

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

 

It has the similar example, where in condition is being matched for another field.