Colors in formula

Maciej29 — Thu, 01 Jul 2021 11:43:18 GMT

How to combine below formula with custom colors for each status ? I need it for bars in bar chart. Any thoughts ? Thanks in advance.

yellow - STARTED

brown - PENDING

red - ON HOLD

blue - IN PROGRESS

purple- IN REVIEW

green- PROCESSED

=If(Match([STATUS],'STARTED','PENDING','IN REVIEW','ON HOLD','IN PROGRESS','PROCESSED'),[STATUS])

Re: Colors in formula

NitinK7 — Thu, 01 Jul 2021 14:56:54 GMT

first create a master dimension for status and field box below exp

=pick(match(Status,'STARTED','PENDING','IN REVIEW','ON HOLD','IN PROGRESS','PROCESSED'),
'STARTED','PENDING','IN REVIEW','ON HOLD','IN PROGRESS','PROCESSED')

and hit create button.

after click this master dimension and edit this

then click value color tab

then set your colors based on status values

and use this master dimension in your chart and color section set color by dimension

topic Re: Colors in formula in App Development

Colors in formula

Re: Colors in formula