Simple Report Showing Status
![Dweb](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I have a Smartsheet for tracking inspections. It has a lot of columns, but primarily focuses on inspection submissions, completions, and report receipts. I am looking for a simple tracker or chart that will visually represent these three columns for my team's overview. Is there any way to create this? I tried a few things last month that did not work out, so I dropped the idea.
Thank you in advance for help! 🙂
Answers
-
Also, I tried report feature but it counts all the line items. I would like it to count only if the box is checked.
-
Hi @Dweb, I suggest using 'Sheet Summary' feature to create counts that are then easy to put into "Sheet Summary Report" type of report and can make charts easy too.
In your case, use "=COUNTIF([Inspection Submitted]:[Inspection Submitted], 1)" for Inspections Submitted,
…and so on, with a Sheet Summary formula for each column you want counted in this way.
If you need more help trying this route, let me know! Happy to take some screenshots of an example if useful.
Good luck!
Will
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives