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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!