Create a dashboard KPI with number of sheets that I have?
I have 1 sheet per product. I need to count this sheets and create a metric in my dashboard. How can I do that?
The bad solution: I created another sheet with columns: name of the sheet(product A, product B,…), Responsible and date of creation, then I use this sheet as a data source for my dashboard, bu its basically rework.
Answers
-
Hi @Geraldo P Junior
Have you considered creating a report with all your sheets, filtering by the top row and then summarizing one of the columns?
This in essence will count your sheetsMarcé Holzhauzen
Solution and Delivery Consultant with Award Winning Partner
Want to meet?Check my availabilitywww.prodactive.co.uk
If this helped, help me & the SSC by accepting it and reacting w/💡insightful, ⬆️ Vote Up, and/or ❤️Awesome.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives