Symbols Formula

Hi all! I am trying to set a IF forumula for symbols changing colors driven by multiple columns.

=IF([BYT RELEASE DATE]@row = 0, "Red", IF([BYT ORDERED]@row = 1, "Yellow", IF([OPEN ISSUES]@row = 1, "Blue", IF(RECEIVED@row = 1, "Green"))))

I can not seem to get the right syntex. Help is appreciated ☺

Find more posts tagged with

Formulas

Accepted answers

Gillian C

Hi @kaowser

I think you need to tie all your columns together in your formula for it to work? Try

=IF(AND([BYT RELEASE DATE]@row <> "", [BYT ORDERED]@row = 0, [OPEN ISSUES]@row = 0, [RECEIVED]@row = 0), "Red", IF(AND([BYT RELEASE DATE]@row <> "", [BYT ORDERED]@row = 1, [OPEN ISSUES]@row = 0, [RECEIVED]@row = 0), "Yellow", IF(AND([BYT RELEASE DATE]@row <> "", [BYT ORDERED]@row = 1, [OPEN ISSUES]@row = 1, [RECEIVED]@row = 0), "Blue", IF(AND([BYT RELEASE DATE]@row <> "", [BYT ORDERED]@row = 1, [OPEN ISSUES]@row = 1, [RECEIVED]@row = 1), "Green"))))

All comments

Gillian C

Hi @kaowser

I think you need to tie all your columns together in your formula for it to work? Try

kaowser

Thank you @Gillian C!! that worked!!

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.