I am having issues referencing multiple columns using the IF statement.

I have 2x formulas:

=IF([Delayed?]@row = "Customer Delay", "Customer Delay")

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

Both work independently from one another. I'd like for this formula to used in the 'Status column (once combined). The challenge I'm having is combining the two into one cell. When I combine them, I get the "UNPARSABLE" message:

=IF([Delayed?]@row = "Customer Delay", "Customer Delay"), IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), "In Progress")))

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Try removing that first closing parenthesis after "Customer Delay".

Vaughn

Ah! I was sooo close! THANK YOU!!!!!!!

Paul Newcome

Happy to help. 👍️

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.