Display Total Sum of each task status
Hello, other than creating a filter view, is there a way to display an active count of each status, for all tasks in a sheet?
e.g. I have 20 tasks with a status of "Open", 15 tasks with a status of "In Progress", and 22 tasks with a status of "Resolved". Without filtering by each status type I'd like to see somewhere, the sum of each status.
Thanks
Answers
-
Andrée Starå ✭✭✭✭✭✭There is an update coming to Reports soon that might be helpful, so you might be able to use that. (late October)
Another option would create a metrics section, us the sheet summary fields, or collect the metrics in a so-called Master Metrics sheet.
Would any of those options work/help?
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 bymarking 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:[email protected]| 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
If your Program list in Sheet 2 is written out to match the option in your form and entries in Sheet 2, then you can just reference those for look up:<\/p>
=COUNTIF({Task Request Range 1},=Program@row)<\/p>
Where \"Program\" is the actual column header you have the list Auto Doors, Baler, Compactors, etc.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":111081,"type":"question","name":"Combining selected cells into one cell ignoring blanks?","excerpt":"Hello all, I am trying to combine cell into one cell and I have found a couple other community posts covering this issue. The only problem is that their solution only applies if you are trying to collect the entire row, I need specific row. Originally, I did this just by using JOIN and then selecting each cell, separated…","snippet":"Hello all, I am trying to combine cell into one cell and I have found a couple other community posts covering this issue. The only problem is that their solution only applies if…","categoryID":322,"dateInserted":"2023-10-02T20:25:16+00:00","dateUpdated":null,"dateLastComment":"2023-10-02T21:09:01+00:00","insertUserID":167760,"insertUser":{"userID":167760,"name":"toca1","title":"User","url":"https:\/\/community.smartsheet.com\/profile\/toca1","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-02T21:06:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":167760,"lastUser":{"userID":167760,"name":"toca1","title":"User","url":"https:\/\/community.smartsheet.com\/profile\/toca1","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-02T21:06:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":42,"score":null,"hot":3392562857,"url":"https:\/\/community.smartsheet.com\/discussion\/111081\/combining-selected-cells-into-one-cell-ignoring-blanks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/111081\/combining-selected-cells-into-one-cell-ignoring-blanks","format":"Rich","tagIDs":[254,587,590],"lastPost":{"discussionID":111081,"commentID":397984,"name":"Re: Combining selected cells into one cell ignoring blanks?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397984#Comment_397984","dateInserted":"2023-10-02T21:09:01+00:00","insertUserID":167760,"insertUser":{"userID":167760,"name":"toca1","title":"User","url":"https:\/\/community.smartsheet.com\/profile\/toca1","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-02T21:06:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-02T20:53:50+00:00","dateAnswered":"2023-10-02T20:52:20+00:00","acceptedAnswers":[{"commentID":397979,"body":"
