Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
i would like to have the button with different color based on the selection on "Item_Category" field.
I set the color configuration as
=if(Match(Item_Category,'FRT' and 'IMP' and 'IMPU' and 'SCN' and 'SMP'),RGB(153,204,255),RGB(192,192,192))
if selection on the field Item_Category= 'FRT' and 'IMP' and 'IMPU' and 'SCN' and 'SMP' then color of button RGB(153,204,255) else
How i can set my expression?
thanks!
use Pick(match(
Pick(Match(Item_Category,'FRT' ,'IMP' ,'IMPU' ,'SCN' ,'SMP'),
RGB(153,204,255),
RGB(192,192,192),
RGB(..),
RGB(..),
RGB(..))
seems that this not works for me.
I try to explain my self better:
if the selection is FRT+IMP+IMPU+SCN+SMP at the same time, so i need to have just 2 color:.
FRT+IMP+IMPU+SCN+SMP -> one color
other selection different than (FRT+IMP+IMPU+SCN+SMP) -> anoter color
if(Match(Item_Category,'FRT' ,'IMP' ,'IMPU' ,'SCN' ,'SMP'),
RGB(153,204,255),
RGB(192,192,192))
Not working, don’t now why..