Using ValueList with Pick(Match(

[onkarkulkarni]

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

[pradosh_thakur]

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))

[onkarkulkarni]

Thanks Pradosh for quick reply. However the solution is not working as expected. All rows are getting highlighted in only one colour.

[pradosh_thakur]

Please attach a screenshot

[valnod_90]

Could you please give us some example data?