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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives