% complete duration

Options

I would like to calculate duration % complete from the actual start and actual end date,

Is there a formula to calculate the duration, should be calculated based on hours (24 hours)


Tags:

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi @Domnic Victor

    If I'm understanding you correctly, you'd like to compare the Actual End Date value with Today's Date to determine how far along a specific task is in percent, is that correct?

    If so, there currently isn't a way to do this using Hours, however you can use NETWORKDAYS to compare two dates and return how many working days are between them. For example, you can find the number of working days between the Start Date and Today's Date, then divide that by the total duration in working days:

    =IF([Actual Start Date]@row > TODAY(), 0, IF([Actual End Date]@row <= TODAY(), 1, NETWORKDAYS([Actual Start Date]@row, TODAY()) / NETWORKDAYS([Actual Start Date]@row, [Actual End Date]@row)))


    Note that I added two statements at the beginning, so if the task hasn't started yet it's at 0%, and if the End Date is in the past (so it's complete) then it's 100%.

    Let me know if this helps and is what you're looking for!

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!