formula running the status column

This is the formula in status. The issue is that if the date is TODAY either in START or in END Date column the status turns to NOT STARTED.

I need the status NOT STARTED only to show up when the start date is in the future =IF(Level@row <> 0, IF(Level@row <> 1, IF([End Date]@row = "", "", IF([Canceled?]@row = true, "Canceled", IF([On Hold?]@row = true, "On Hold", IF(AND([Start Date]@row < TODAY(), [Task Complete?]@row = false, [End Date]@row > TODAY()), "In Progress", IF(AND([Start Date]@row < TODAY(), [Task Complete?]@row = false, [End Date]@row < TODAY()), "Overdue", IF([Task Complete?]@row = true, "Complete", "Not Started"))))))))

Find more posts tagged with

Formulas

Accepted answers

All comments

Genevieve P.

Hi @Agata Wozniak

It looks like you're just missing an = sign before some of your date comparisons!

For example, instead of:

IF(AND([Start Date]@row < TODAY(),

You'll want to put:

IF(AND([Start Date]@row <= TODAY(),

See Formula Operators in this Help Article: Create and Edit Formulas in Smartsheet

With this in mind, try:

=IF(Level@row <> 0, IF(Level@row <> 1, IF([End Date]@row = "", "", IF([Canceled?]@row = true, "Canceled", IF([On Hold?]@row = true, "On Hold", IF(AND([Start Date]@row <= TODAY(), [Task Complete?]@row = false, [End Date]@row >= TODAY()), "In Progress", IF(AND([Start Date]@row <= TODAY(), [Task Complete?]@row = false, [End Date]@row <= TODAY()), "Overdue", IF([Task Complete?]@row = true, "Complete", "Not Started"))))))))

Cheers,

Genevieve

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.