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

Find more posts tagged with

Sheets

Reports

Automations

Sheet Summary

Accepted answers

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

All comments

Heather Duff

Hi Evgeniya,

=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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.