Unparseable Error

Ashley L.

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.

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!

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

=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!

Paul Newcome

Happy to help. 👍️