IF this, if this, if this, if not formula help

=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row <= 0.99, IF([% Complete]@row >= 0.01, "In Progress", IF(Review@row = 1, "Review")))

This formula works perfectly. Until I add this at the end, "To Do".

If it doesn't fall into one of the categories, I need it to say "To Do".

I've tried multiple things, but it just won't work all together.

This is an expanded Status update. Thank you

% Complete is 1 = Complete

% Complete is 01-.99 & Flag is 0 = In Progress

% Complete is 0 & Flag is 1 = Review

otherwise = To Do

Thank you!

Find more posts tagged with

Accepted answers

All comments

Jason Tarpinian

=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row <= 0.99, IF([% Complete]@row >= 0.01, "In Progress", IF(Review@row = 1, "Review", "To Do"))))

Should just need to update your final FALSE IF statement with "To Do".

Angie Hatfield

@Jason Tarpinian Thank you. Not sure what was happening, but I am good to go now.

Thanks so much!

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.