I need to record the date something is "closed" in a column, and then count the number of times on t
I have a project where we will call something "closed", I then have an automation that records the date that "closed" was selected. I need to take that data and record the number of times closed happened on each date. My project will span about 60 days, so I'd need to know each time it happened on each date of the project. Any suggestions on how to capture this information?
Answers
-
I hope you're well and safe!
Have you explored using a Report?
Would that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. 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.
-
I need the data to be able to make a chart on a dashboard showing the progress, so a report, with my limited knowledge, would not be able to feed the dashboard in real time, rather than making multiple reports per day and then trying to pull that data into the dashboard. I'd like to automate it in real time.
-
@Aviation Rob I would do it this way:
- Project sheet has a status column with "Closed" as an option, and automation to capture the date this occurred
- Separate summary sheet with dates that span your 60 day period
- #closed column counts the number of times for each day that a task was closed
- Develop a report from the summart sheet. This is where you can filter e.g. ignore zero or only show dates in the past
- Use the report as the data source for a chart
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!