conditional formatting SharePoint list column - help

%3CLINGO-SUB%20id%3D%22lingo-sub-2134898%22%20slang%3D%22en-US%22%3Econditional%20formatting%20SharePoint%20list%20column%20-%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2134898%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20help%20provide%20the%20JSON%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%205%20columns%20in%20SP%20list%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20PO%20amount%2C%20invoice%20amount%2C%20approver%20and%20completed%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20create%203%20status%20for%20these%20three%20columns%3C%2FP%3E%3CP%3E1)%20when%20PO%20amount%20in%20input%26nbsp%3B%20the%20status%20will%20show%20as%20done%26nbsp%3B%3C%2FP%3E%3CP%3E2)%20When%20invoice%20amount%20is%20in%20it%20will%20show%20as%20received%20invoice%20and%20send%20to%26nbsp%3B%20approver%20or%202%20other%20department%20-%20finance%201%20and%20finance%202%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhen%20approver%20approved%20or%20finance%201%20and%202%20are%20been%20complete%20it%20will%20also%20show%20complete%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2134898%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
Contributor

Hi

 

Can someone please help provide the JSON?

 

I have 5 columns in SP list 

1) PO amount, invoice amount, approver and completed

 

I want to create 3 status for these three columns

1) when PO amount in input  the status will show as done 

2) When invoice amount is in it will show as received invoice and send to  approver or 2 other department - finance 1 and finance 2 

 

when approver approved or finance 1 and 2 are been complete it will also show complete

 

thanks

0 Replies