due date changing the status?

Hello guys,

I'm working on my project plan sheet and i'm facing some difficulties formatting the columns,

How to change the Status based on due date (if the today's date pass the due date, the status column changed to something else *red (delayed)* for example)

Here are the down list of columns:

Status: Started, on hold, completed, delayed, not started

and the dates columns: Start date, end date, due date

Thanksss!!

Find more posts tagged with

Accepted answers

All comments

Kelly Moore

Hey @Yazeed Alsaleh

You can accomplish this using a nested IF statement. Here is one recent example https://community.smartsheet.com/discussion/comment/309966

If you provide the conditions of the colors to the community, we can help you build the formula.

cheers,

Kelly

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.