Sheet summary formula
I have several status for work in progress. They are very detailed and granular (not started, writing in progress, review 1, revisions 1, review 2, revisions 2, editorial, final review, ready for client). I would like to create a sheet summary that counts several of these statuses together (example: grouping writing in progress, review 1, revisions 1).
Is it possible to group these into one formula for the sheet summary?
How would I modify the basic formula: =COUNTIF(Status5:Status13, "Writing in Progress")
Thank you.
Answers
-
Hi @AnneSophie ,
You can use "Countifs" to apply multiple criteria. https://help.smartsheet.com/function/countifs
Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!