How to determine if a milestone is an extended milestone?

eman

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?

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