Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Could you please help me with replacing if conditions with pick(match :
if(deadline < 30, rgb(255,0,0), if(deadline <60 and deadline >30, rgb(255,128,0), rgb(0,255,0)))
Regards,
Onkar
try this
pick(match(-1,deadline < 30,deadline <60 and deadline >30)+1,rgb(0,255,0),rgb(255,0,0), rgb(255,128,0))
Could you please give us some example data?