Using Smartsheet Baselines values

Jenann

Is there a way to use a helper Column and Formula to turn a Smartsheet Baseline variance into a real number so I can get an average? OR is there a better way to baseline changes to end dates?

Brian_Richardson

You can take an average directly on Variance =AVG(Variance:Variance)

The number returned will be a normal number, not appended with the duration indicator like d. The number returned is number of days. Variance is always in days, regardless of the duration.