Count if formula for starred/checkbox - help!

laura.sandoval ✭✭✭
edited 02/28/24 in Formulas and Functions

This might be a silly question but I'm stuck...a little rusty! I am trying to do a count formula for a dashboard that has a summary of how many sites are activated using this column whenever it's starred.

The formula will be on a separate sheet used for dashboard metrics. Is it

=COUNTIF(Sheet reference), HAS(@cell))

I know this is wrong but I'm stuck. Would love some help!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!