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

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)))))

Find more posts tagged with

Manufacturing

Construction

Government

Product Development

Project Management

Comments

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.