IF formula assistance

System

This discussion was created from comments split from: Formula to link End date and Health status.

Mike_J_B

Hi all..this has been a great help! Question I have is if I want to add more than one status value into the string, as well as taking the date into consideration, how would that look?

Example below with one status but I would need multiple status' in the string. Should note that the result of the status would need to be driven by an 'OR' function as I have a few that it could be. New, In Process, In Review, etc., etc..

=IF(AND(Status@row = "In Process", [Requested Finish Date]@row < TODAY()), "Red")

Thanks in advance!! We just implemented Smartsheet as our group's solution and being a new admin I'd appreciated any help! :)

Paul Newcome

You would drop an OR statement inside of the AND as its own "argument" within the AND function.

=IF(AND(OR(…………), Date@row < TODAY()), "Red")

=IF(AND(OR(Status = "In Process", Status = "Something Else"), [Request Finish Date]@row < TODAY()), "Red")