Formula Support

AGM

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.

Paul Newcome

What you need is a nested IF statement.

=IF(1st_argument, 1st_true, IF(2nd_argument, 2nd_true, IF(3rd_argument, 3rd_true, if_all_false)))

Basically you nest the next IF inside of the 3rd portion of the preceding IF.