Add Ons and Integrations
Add Ons and Integrations
Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.
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.
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
- 67.7K Get Help
- 472 Global Discussions
- 200 Use Cases
- 514 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 520 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
