Unable to convert column to a formula

Options
betcha663
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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!