Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have created a few maps using google maps and scatter graphs with coloured pins using following formula:
If(count ([Asset.Serial #])=0, Red(), if (count ([Asset.Serial #])=1 , Yellow(),if (count ([Asset.Serial #])=2, Black() , if (count ([Asset.Serial #])=3 ,Black(), )))
Which works fine.
Howerver I now want to do the same but for a field value instead of a count and I cant seem to get the below to work:
If (Fieldvalue ([Activity.Type])='Demonstration', Red(),)
Many thanks
Paul
Hi,
did you try with
If ( [Activity.Type]='Demonstration', Red())
or using the pick/match function
pick(match( [Activity.Type],'Demonstration'), Red()....
Hi,
did you try with
If ( [Activity.Type]='Demonstration', Red())
or using the pick/match function
pick(match( [Activity.Type],'Demonstration'), Red()....