Formula to assign colored dot symbol based on field?
Hello all. I am trying to utilize the colored symbol dots (green, red, blue, etc) while also having a text field specifying what the status of an item is.
In my case, I am looking to have the following:
Column A (Status) ------ Column B (Status Dot)
Available ------ Green
Pending ------ Yellow
Unavailable ------ Red
I want to populate the status dot column B based on the selected status of Column A.
If status is Available, set column B to Green
If status is Pending, set column to Yellow
Would anyone be able to help me with creating a formula for Column B based on this info?
Help Article Resources
Check out the Formula Handbook template!