Using IF formula to update status based on % complete column

Hi all -

Need some help with an IF formula

Goal: status updates automatically to "Not Started" (when % complete is 0), "In Progress" (when % complete is >0 but <1) or "Complete" (when % complete is 1) based on value entered in "% Complete Column"

I've started here, and this formula works; but when I include additional conditions I get an 'unparsed' error so clearly I'm breaking my formula somehow. Has anyone done this or can you help!?

Find more posts tagged with

Formulas

Accepted answers

tori.wyne

Ashley, got it thank you I see that I missed that in your initial post. I think this would be easier to accomplish with Automation. I attached a screenshot of what this would look like, but let me know if you have any questions!

All comments

tori.wyne

Hi Ashley, can you share what additional conditions you're trying to add? This might determine the formula needed and help better understand the unparsed error.

AshleyV33

@tori.wyne I'm hoping to have my status column update based on the % complete as follows: "Not Started" (when % complete is 0), "In Progress" (when % complete is >0 but <1) or "Complete" (when % complete is 1)

tori.wyne

AshleyV33

Thank you @tori.wyne ! This is exactly what I needed - I always forget to use automations to my advantage. Thanks again :)

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.