Project Milestones Metric Help



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!



  • SteyJ
    SteyJ ✭✭✭✭✭✭

    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.


    Jacob Stey

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!