Calculate percentage complete on a project based on time elapsed


I need help to finish a schedule for projects based on time elapsed. The current formula that I am trying to use has a Datedif formula but I don't think Smartsheet supports that. Any ideas or assistance would be helpful?

=DATEDIF([Projected Start Date]@row, [Projected Finish Date]@row,[Actual Finish Date]@row)/DATEDIF([Projected Start Date]@row,[Projected Finish Date]@row,[Actual Finish Date]@row)


  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Linda F 

    Hope you are fine, try to use the following formula

    =(TODAY() - Start@row) / (Finish@row - Start@row)

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Linda F
    Linda F ✭✭✭✭✭
    edited 01/13/21

    Hi Bassam

    Thank you for your suggestion - =(TODAY() - [Actual Start Date]@row) / ([Actual Finish Date]@row - [Actual Start Date]@row)

    It gave me an # DIVIDE BY ZERO message. The formula is above that I used. Is it brackets that caused the error?

  • Shelby
    Shelby ✭✭✭✭✭
    edited 02/19/21

    @Linda F

    Here's what worked for me:

    =NETWORKDAYS([Start Date]@row, TODAY()) / Duration

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!