Counting values
I have over 30 sheets which I store the portfolio the belong to in a sheet summary field (a drop down). I am needing a way to count these values. I am wanting to count how many schedules have the value "ETG Project Portfolio 2020" in the Portfolio summary field.
thanks in advance for the help.
Best Answer
-
Hi @ScottPinson_AlliedSolutions
Depending on if the new report update that is coming soon will have grouping features for the Sheet Summary Reports. (I think it will work) You could use that.
Otherwise, the best option would be to link the Sheet Summary values to a row in each sheet and then link it to a so-called Master Metric Sheet.
Make sense?
Would that work?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Hi @ScottPinson_AlliedSolutions
Depending on if the new report update that is coming soon will have grouping features for the Sheet Summary Reports. (I think it will work) You could use that.
Otherwise, the best option would be to link the Sheet Summary values to a row in each sheet and then link it to a so-called Master Metric Sheet.
Make sense?
Would that work?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks for the reply. that is what I has thought but thought someone might have an idea that I couldn't think of.
Thanks,
Scott
-
I'm always happy to help!
Hopefully, the new report features will make this simpler. Soon we'll now!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K 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
Check out the Formula Handbook template!