Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

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

John Plecki
John Plecki ✭✭✭
edited 12/09/19 in Archived 2017 Posts

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


This discussion has been closed.