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!

Find more posts tagged with

Formulas

Accepted answers

All comments

SteyJ

https://community.smartsheet.com/discussion/109802/project-milestones-metric-help

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.