Forcing duration and start date to a specific value on Gantt

ilene_healy68056
ilene_healy68056 ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Dear Community,

Is it possible to set a formula so that the Start Date always equals the End Date and that the Duration is always '0'?  We are tracking key milestones and are only provided the End Date.  I'd like to reduce the manual entry to automatically make the Start Date match the End Date and ensure that the Duration is set to 0 so that they show up as milestones on our Gantt chart.

Thanks for any advice

Ilene

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!