Unable to convert column to a formula

betcha663 ✭✭
edited 04/05/24 in Formulas and Functions

I am trying to convert the following cell formula to a column formula to adjust the duration relative to the allocation percentage:

=IF(OR(Duration@row = "", Duration@row = 0, [Allocation %]@row = "", [Allocation %]@row = 0), "", ROUND(Duration@row / [Allocation %]@row))

The cell menu option -> "Convert to Column Formula" is dimmed out.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!