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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!