How to determine if a milestone is an extended milestone?

The formula value of [Duration]@row is a numeric value of 0 for both a Duration cell value of 0 and ~0.

This means it is not possible to determine the number of work days that Smartsheet will then use for scheduling and % Complete calculations.

Does anyone know if there is a way to determine which Duration cell value has been input by the user?

Find more posts tagged with

Formulas

Project Management

Accepted answers

All comments

Paul Newcome

Are you able to provide a screenshot for context?

Genevieve P.

Hi @eman

I agree that it would be helpful to see screen captures and a more detailed description of what it is you're looking to do. You can use the Cell History to see when data has been added or changed to a cell (by right-clicking on the cell), if that helps.

Cheers,

Genevieve

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.