Convert Cell Formula to Column Unavailable

Hi,

I want to convert this formula to a column formula, but it's greyed out and won't let me.

=[Baseline Duration]@row - Duration@row

I'm trying to get a duration variance in my schedule. Both columns are type Duration. The formula seems to work fine in the cell.

Thanks!

Answers

  • John Shane
    John Shane ✭✭✭✭

    @Ariane

    Unfortunately, certain types of columns do not support column formulas and Duration is one of those. Is there another type of column you can use in its place?

    Cheers,

    John

  • Ariane
    Ariane ✭✭

    Ah that makes sense. I'm not sure what else I could use. I'm trying to understand the difference between the planned duration and the actual. I wonder if there is a way to get rid of the right most character (d or w) and then do a formula with the raw numbers?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!