Unparseable Error

Hi,

I would like to add a health status formula but i am receiving an error.

=IF(Status@row = "Not started", "Blue", IF(Status@row="In Progress", "Yellow", IF(AND(TODAY() > [end date]@row, Status@row="In Progress"), "Red", IF(Status@row="Complete", "Green"))))

Any help would be greatly appreciated.

Find more posts tagged with

Accepted answers

Ashley L.

Yes and i realized i was missing some additional parenthesis.

Correct Formula

=IFERROR(IF([% Complete]@row = 1, "Blue", IF((1 - (NETWORKDAYS(TODAY(), [End Date]@row) / Duration@row)) - [% Complete]@row >= 0.2, "Red", IF((1 - (NETWORKDAYS(TODAY(), [End Date]@row) / Duration@row)) - [% Complete]@row >= 0.1, "Yellow", "Green"))), "")

Thank you so much!

All comments

Paul Newcome

Are you able to provide a screenshot of the formula in the sheet similar to the screenshot below?

Ashley L.

I updated the formula but i am still receiving Unparseable error.

Paul Newcome

It looks like you have some misplaced parenthesis in this new formula. Try removing the opening parenthesis before the first NETWORKDAYS function.

Ashley L.

Yes and i realized i was missing some additional parenthesis.

Correct Formula

Thank you so much!

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.