How to count symbols in smart sheet ? example the risk flag

Preetha Luther

=COUNTIFS({Main Deck Range 1}, "Body", {Main Deck Range 2}, [34 System - Unassigned]1, {Main Deck Range 4}, <>"", {Main Deck Range 8}, 1)

 

This formula doesn't seem to work Range 8 is the reference to the column that has the symbols

L_123

double check the range and make sure it has the same size range as the others. Flags are referenced as 1 or 0 so the syntax seems to be correct, it is most likely the reference causing the issue.

Mike Wilday

What symbols column are you using? 

You have to know what "Text" is being used to create the symbols in the symbols column and then you can reference that text to check for the symbol. 

There are some clues here: https://es.smartsheet.com/node/2217

and this one also gives some clues: https://www.smartsheet.com/blog/support-tip-automate-RYG-balls

This one also has a few clues: https://community.smartsheet.com/announcement/working-symbol-formulas

Preetha Luther

Thank you seems to work now