1 Symbol is not updating with fomula

I am using the RGB balls for tracking tasks. I have red set to activate if the date in the finish column is in the past.

The other 3 color denote status of the task.

Formula: =IF(Status3 = "Not Started", "Gray", IF(Status3 = "In Progress", "Yellow", IF(Status3 = "Complete", "Green", IF(Finish3 < TODAY(), "Red"))))

GRAY, Yellow, and Green all work on the row, just the Red one is not working.

Thanks

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @Fozzybythesea

I hope you're well and safe!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Fozzybythesea

I Just shared the sheet with you with some additional information.

Thanks

Fozzybythesea

it does work on an empty field. just not rows with data.

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.