How to count tasks across all sheets in a workspace
I have a master metrics sheet that I am using. I'd like to be able to count tasks by assigned to across all sheets in a workspace. The goal is to have this formula work if/when any new sheet is added to the workspace.
Reports are not really working for me because my assigned to column is a multi-select column. I don't see a way to add a 'Workspace' as a source to a countif forumla.
The end goal will be able to build a metric or chart in a dashboard to display the data.
Tags:
Answers
-
Change your assigned to column to a single select drop down column or make a redesign of your sheet so that what you want to accomplish is do-able with the tools we're given.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives