Formula Help


Just wondering if someone could help me update this column formula. I need it to exclude the N/A status. It is currently a column formula column that flags any items that are past due from the End Date column.

=IF(AND([End Date]@row < TODAY(), NOT(ISBLANK([Program Status Type]@row)), NOT(Status@row = "Complete")), 1, 0)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!