Variance Column Unparseable

hi i have 2 types of Start and End date.

i have Actual start date, Actual End date and Actual Duration.

also, i have Planned Start Date, Planned End Date, and Variance (for Baseline).

the Actual duration is the duration of the task based on the Actual start & Actual End date.

what i want is to be able to calcuate a Planned Duration (a duration based on the Baseline Dates). **Not (Planned End date - Planned Start Date))

how to do it? is there a formula?

Also, in the Variance Column, it is Unparsable, why?

please help thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!