I am trying to add a formula that will update my "Current Status" with the associated Color Ball based on the "Schedule Status" column.
I have the below formula that is working. However, it does NOT account for multiple options. As I have four different color balls and five "Schedule State" options to coordinate.
Current Formula that is working for single option
=IF([Schedule State]@row = "Accepted", "Blue")
Please help.
If anyone is available to meet for 5-10 min to trouble shoot this, I would be extremely grateful.
