Calculate percentage complete on a project based on time elapsed

Linda F

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

Hi @Linda F 

Hope you are fine, try to use the following formula

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

Linda F

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

@Linda F

Here's what worked for me:

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