Date formula / duration question

Hi there,

I have a Start Date column, an End Date Column, and a Duration (days) column.

When the Start Date column is populated, I'd like for the Duration (days) column to count the number of days between start date until today. Only once the End Date column is populated, would I like for the Duration (days) column to lock the number of days and stop counting based on today's date.

Thank you in advance!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!