Formula IF Statement

Catherine Shea

I am trying to get the Cleaning Progress to Show "In Progress" when the #Days are greater than 1 but if the Cleaning End Date is populated to return "Complete"

Capture.JPG

Devin Lee

@Catherine Shea

Feel free to change the "Error" into whatever message you want. You need a third option for when the Cleaning End Date is empty and the #Days are less than or equal to one.

=IF([Cleaning End Date]@row = "", IF([#Days]@row > 1, "In Progress", "Error"), "Complete")

Catherine Shea

Thank you, that did work. How would that third option be written? Does it get strung to the existing one you supplied.