% complete using a duration of dates

Heather_Goetz_DAL

I am trying to get a percent complete using dates. For example, I have a start date and a finish date to get the duration (let's say that is 96 days) and I want to find out the percent complete using today's date (automatically updated each day) as the task progresses in time. I can't seem to figure out how to use TODAY() in the formula to return the result.

=Chris Palmer

Hello @Heather_Goetz_DAL

Is this what you're going for?

=IF(TODAY() < Start@row, 0, IF(TODAY() >= Start@row + VALUE(SUBSTITUTE(Duration@row, "d", "")), 1, (TODAY() - Start@row) / VALUE(SUBSTITUTE(Duration@row, "d", ""))))

=Chris Palmer

Hello @Heather_Goetz_DAL

Is this what you're going for?

=IF(TODAY() < Start@row, 0, IF(TODAY() >= Start@row + VALUE(SUBSTITUTE(Duration@row, "d", "")), 1, (TODAY() - Start@row) / VALUE(SUBSTITUTE(Duration@row, "d", ""))))

Heather_Goetz_DAL

yes thank you very much

=Chris Palmer

https://community.smartsheet.com/discussion/comment/465335#Comment_465335

Great! Happy this worked for you :-)