Sheet summary - column formula
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
Best 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!
Best,
Heather
Answers
-
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
-
Yes thank you so much!
-
Happy to help! Enjoy your weekend.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!