Status Update Formula

Martha Hemingway

Hi team, I have lost one of my most favorite formulas as a project manager. Here's what I'm trying to accomplish:

If % Complete is 100% - select "Complete" for the status column.

If % Complete is between 1-99% - select "In Progress" for the status column.

If % Complete is 0% - select "Not Started" for the status column.

Thanks all!

Find more posts tagged with

Formulas

Project Management

Accepted answers

Adam Murphy

Hi @Martha Hemingway, try something like this:

=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row < 1, "In Progress", "")))

All comments

Adam Murphy

Hi @Martha Hemingway, try something like this:

=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row < 1, "In Progress", "")))

heyjay

https://community.smartsheet.com/discussion/140284/status-update-formula

=IF([% Complete]@row  = "", "", 
IF([% Complete]@row  = 1, "Complete", 
IF([% Complete]@row  = 0, "Not Started", 
"In Progress")))

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.