Sheet summary - column formula

Evgeniya Nazarnaya

Hello,

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

Heather Duff

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!

Best,

Heather

Heather Duff

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!

Best,

Heather

Evgeniya Nazarnaya

Yes thank you so much!

Heather Duff

Happy to help! Enjoy your weekend.