IF Formula Help

Torsten Schopf

Hi guys,

I would like to implement the following automation process of "% Complete" -> "Status".

The approach would be:

IF: % Complete: 0% -> "Not Started"
IF: % Complete: 0% ≤x≤ 100% -> "In Progress"
IF: % Complete: 100% -> "Completed"

My current IF formula does not display and consider the last 2 conditions, I honestly do not know why.

Could anybody help me on this? :)

Many thanks in advance!!!

Best regards,

Torsten

Find more posts tagged with

Sheets

Formulas

functionality

Accepted answers

Tim Shaded

Hello Torsten,

You can try the formula below. The thing to remember with nested IF statements is that they get processed from left to right. This allows for logic on the last IF statement to simply look for greater than 0, but still show as complete when it equals 1, as the second IF statement takes priority over the last one.

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

Hope this helps.

All comments

Tim Shaded

Hello Torsten,

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

Hope this helps.

Torsten Schopf

Amazing, it works!! Thanks a lot Tim!! :)

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.