Highlighting Past Due Items for Different Dates

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?

Find more posts tagged with

Formulas

Conditional Formatting

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.