Formulas

How can I make this work? I am missing something? If someone enter 100% I would like the Task Status to be populated with Complete, or any number between 1%-99% "In progress, and 0% with not started

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

Find more posts tagged with

Accepted answers

All comments

Michael Drayton

Hey Friend, Let me know if this works!

Try changing your formula where it says "100%", change that to just say "1".

See if that fixes your problem.

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

Good Luck!

bbates

Percentage values are 0-1 which is the issue here, try this:

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

sanchezf

Thank you! That worked!!!

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.