Comparing Actual Duration to a Projected Duration with a +/- days

John Plecki

Three columns used are Duration(dependent), Projected Duration(I initially copy all of the durations over when setting the project) and +/- days(calculates the difference between Duration and Projected Duration)  The trick here is you need to strip the "d" from the value to allow computations.

=(VALUE(LEFT([Projected Duration]9, (LEN([Projected Duration]9) - 1)))) - (VALUE(LEFT(Duration9, (LEN(Duration9)))))

Adam Overton

Cool! Did you also have a question?

 

John Plecki

No question.  When contacted Smartsheet to see if this could be done they did not have answer.  It was difficult because of the type of column and data within the cell.  I wanted to share it with the community.