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

Preetha Luther
edited 12/09/19 in Smartsheet Basics

=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