Help with Stacked IFs for Color Balls

=IF(Status@row="Complete","Blue",IF((AND[Actual Start Date]@row=[Start Date]@row,Status@row="In Progress"),"Green",IF(AND([Actual Start Date]@row<>[Start Date]@row,Status@row="In Progress"),"Yellow",IF(AND([Actual Start Date]@row<>[Start Date]@row,Status@row<>"In Progress"),"Red"))))

Tired eyes, I know I'm missing something can can't figure it out.

I am tried to have a symbol column that shows green, yellow, red, blue as follows:

1) when Status@row is "Complete" show blue ball

2) when [Actual Start Date]@row equals [Start Date]@row and Status@row is "In Progress" show green ball

3) when [Actual Start Date]@row is not equal to [Start Date]@row but the Status@row is "In Progress" show yellow ball

4) when [Actual Start Date]@row is not equal to [Start Date]@row, and Status@row is not equal to "In Progress" show red ball

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hi @Stepheni Norton

It looks like you're missing an open parentheses after an AND, and you have extra parentheses after an IF! I've bolded the correction.

Try this:

=IF(Status@row = "Complete", "Blue", IF(AND([Actual Start Date]@row = [Start Date]@row, Status@row = "In Progress"), "Green", IF(AND([Actual Start Date]@row <> [Start Date]@row, Status@row = "In Progress"), "Yellow", IF(AND([Actual Start Date]@row <> [Start Date]@row, Status@row <> "In Progress"), "Red"))))

Cheers,

Genevieve

Stepheni Norton

Oh! Thank you! Tired eyes get me every time!

Thank you so much😊

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