Highlighting Past Due Items for Different Dates

Laura A

I’m looking for a way to highlight when a date exceeds 5 business days without explicitly setting due dates. For example, if I enter a submission date as 2/3, how can I automatically highlight it as past due on 2/10? Any suggestions on how to track this in Smartsheet?

Each line has a different request with different submission dates. Is it possible to have this as a general rule?

Melissa Yamada

@Hello @Laura A

You might need a helper column to define which are past due.

For example a checkbox column with this formula:

=IF(WORKDAY([End Date]@row, 5) = TODAY(), 1, 0)

Then set a conditional formatting to highlight those past due.

Laura A

Thanks, Melissa.

Any tips on how to do it if the dates are all different? I can't figure out how to set it to past 5 business days.