IF Function With Multiple Drop Down Selections

David Bramer

I am not sure how to "Nest" if functions for my application or if I need to use the "AND / OR" functions with it.

Essentially, when my field team updates the [Field Status] column I want the appropriate colored circle to update in the [Risk Status] column.

Red = Delayed

Gray = Not Started

Yellow = In Progress

Green = Completed

*Bonus if you can help with this one below.

I would also like the [Risk Status] to automatically become a red circle IF the [EWD] column is past TODAY's date OR if [Field Status] = Not Started AFTER the [SWD] column has passed.

bisaacs

Hey @David Bramer,

I think you'd want it to look something like this:

=IF(OR(EWD@row > TODAY(), [FieldStatus]@row = "Delayed", AND([Field Status]@row = "Not Started", TODAY() >=SWD@row)), "Red", IF([Field Status]@row = "Not Started", "Gray", IF([Field Status]@row = "In Progress", "Yellow", IF([Field Status]@row = "Completed", "Green"))))

Nested IF statements are definitely doable!