Smartsheet Function that Calculate Number of Days Between Today's Date and the Task End Date

Hi,

I need help creating a formula to help me a couple of things.

1) First, I want to calculate the number of days from Today to the End Date of a task.

2) Then based on the number returned, I want to setup Conditional Formatting to highlight the Status column Red (0-2 days), Yellow (3-4 days) or Green (5+ days).

Is this the NETWORKDAY Function and if so, can you share how to set this up or what the formula is?

Thanks for your help!

Des

Find more posts tagged with

Formulas

Accepted answers

All comments

J Tech

Hi Des,

In your days remaining you could enter [End Date]@row-Today()

Based on the above you can simply setup conditional formatting.

Des

Thanks, JTech. I was able to configure the following formula which worked:

=NETWORKDAYS(TODAY(), [End Date]@row)

I then used that column to add Red, Yellow and Green symbols with this formula:

=IF([Working Days]@row < "4", "Red", IF([Working Days]@row < "6", "Yellow", IF([Working Days]@row > "5", "Green")))

But how do I stop the RYG formula from populating blank cells, like cells in the parent row and a few rows of text above the actual project schedule we we've entered some additional text?

Des

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.