Nested OR, AND, IF

Hi All,

I am only a week 1 user so forgive if this is a little basic. I have a flag/no flag column in my sheet that currently indicates whether a report is overdue based on the status of the project, due date of the report, todays date and whether a report has been submitted (entered in the shseet as a date). The format currently works like this

=IF(AND([Interim Report 1 Due]@row < TODAY(), [IR 1 Received]@row = "", Status@row = "in progress"), 1, 0)

I would like to add an OR criteria (Status@row = "completed") to show both In Progress and Completed projects that have overdue reports.

I cannot seem to work out where to slip this little criteria and the operator in. Any help would be appreciated.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!