Convert Cell Formula to Column Unavailable
Options
Ariane
✭✭
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

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

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
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!