Sheet summary - column formula



I am creating a smartsheet that aggregates the clubs that certain employees are in. That main component is done, and I am now using the sheet summary function now (mostly using COUNTIF) to link to a dashboard.

However the number of entries on the sheet will change with new employees, which makes the sheet summary formula range go off.

Is there a way to do a "column-formula" equivalent for the summary sheet?

Thank you

Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓

    Hi Evgeniya,

    Yes! You'll simply use the [column name]:[column name] in your formula. For example, if you're counting the number of times "Cooking club" is listed in a "Club assigned" column, it would look like this:

    =countif([club assigned]:[club assigned],"Cooking Club")

    Hope this helps!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!