How to determine if a milestone is an extended milestone?

Options

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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!