IF Formula (Due Date > Today's Date AND Request On Hold (Box Checked) = No Flag In Past Due Column)



I am trying to troubleshoot a formula to achieve the following outcomes.


If the Due Date column is past today's date, trigger a flag in the "Past Due" column.


If the "Due Date" column is past today's date AND the "Request On Hold" column has a check box, NO flag in the "Past Due" column.

Database Screenshot:

Current Formula:

=IF(AND([Due Date]@row < TODAY(), 1, 0), [Request On Hold]@row, false)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!