Help calculating the state (Status) column so I don't have to manually update it

Irina

Here is the formula I am using:

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

The "Not Started" and "In Progress" work well, but not the 100% complete.

Find more posts tagged with

Accepted answers

Mark Cronk

Hi Irina,

Try:

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

Mark

All comments

Mark Cronk

Hi Irina,

Try:

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

Mark

Irina

Thank you so much @Mark Cronk that was extremely easy to fix. I thought it was expecting the actual value I was passing (100). Thank you!!

Mark Cronk

Happy to help. Thank you for contributing to the Community.

Mark

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.