Hello, I'm after some help with getting a circle (shape) to change colour based on the value selected from a dropdown field.
The dropdown has three options, "Red", "Amber" & "Green".
I'm trying to get a circle within the same card to change colour based on the selected value.
So far, I have tried an IF formula or the SWITCH formula. When using the Switch formula it doesn't appear to bring up any errors, however it doesn't appear to work.
The formula used is;
Switch(ThisItem.'Overall Project RAG'.Value,
"Green", Green,
"Amber", Orange,
"Red", Red)
Many thanks
