Project Milestones Metric Help
Hi,
I'm a newbie SmartSheet Admin for my organization and am still trying to get my head around some of the ins and outs of the tool, so apologies if this is a basic question!
At my organization, one of the core metrics we're supposed to report on is the number of project milestones completed within +/- 4 weeks of the target end date. I'm struggling with creating a formula to capture that. If anyone has any ideas for options I could test out, I'd really appreciate it!
Answers
-
For these types of metrics, I usually incorporate fields in the Sheet Summary option, then I can build beautiful graphs based on this data. I also recommend going to smartsheets own SmartU to learn the core features of smartsheet for free (there are also paid options available, too)
If you'd the community to help build metrics for you, we will need to know the structure of your sheet. For instance, to count specific project milestones, we will need to know which column names to use.
If you'd like to share your sheet and redact PII, that would be a great help.
Sincerely,
Jacob Stey
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!