Logic Condition Formula (color symbol) is not working

I have been using a condition/logic formula on my sheets for 4 months. Today when I logged in, the formulas are not working correctly. Has anyone else experienced this issue? This has affected multiple sheets with same/similar formula.

=IF([Next Action]@row = "Actively Monitoring", "Yellow", IF([Next Action]@row = "Termination in Process", "Red", IF([Next Action]@row = "Maintain", "Green", IF([Next Action]@row = "Enrolled", "Green", IF([Next Action]@row = "Opt Out In Process", "Yellow", IF([Next Action]@row = "Request EOB", "Yellow", IF([Next Action]@row = "EOB Submitted", "Yellow"))))))))

Find more posts tagged with

Conditional Formatting

Accepted answers

All comments

Paul Newcome

What exactly do you mean by it isn't working?

Shannon Kania

Previously the formula worked correctly and populated the field with a colored symbol. The formula does not update the field. It remains empty. If I attempt to manually choose a colored symbol, it doesn't allow the change and remains blank.

Paul Newcome

Are you able to provide some screenshots for context?

Shannon Kania

Paul Newcome

I have been seeing this pop up quite a bit lately but haven't seen any resolution (yet). I would suggest reaching out to Support.

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, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.