Symbols Formula

kaowser

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 ☺

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"))))

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"))))

kaowser

Thank you @Gillian C!! that worked!!