DATEDIF for %Complete

Melita Clark

Hi!

I am wanting to write a formula to automate %Complete column. I have the start date / duration / end date. In excel I would write - =DATEDIF(A1, TODAY(), "D")/B2 - to find the difference between the start date and today's date and then divide by the duration. How do I do this in smartsheet?

Thanks in advance!

Mark Cronk

Hi @Melita Clark ,

Try:

=(TODAY()-[Start date]@row)/duration@row

Mark