Unable to convert to column formula

I am trying to convert the following cell formula to a column formula:

=IFERROR(IF([Duration to Transport and Return]@row * $Column$1 <= 0, "", [Duration to Transport and Return]@row * $Column$1), "")

I keep on getting the following :

What am I doing wrong? Any assistance would be grateful.


  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭

    If you have absolute references in your formula (like your $Column$1) you cannot convert it to a Column Formula.

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭
    edited 03/26/22

    Hey Vinton!

    As Sameer said, you can't have absolute references in formula if you want to make it a column formula

    Here's your workaround:

    1.)Create a Helper Cell in your Sheet Summary.

    2.)Make that look @ $Column$1 (e.g. =$Column$1)

    3.)Then make your Column Formula look at the Sheet Summary Helper Cell:

    =IFERROR(IF([Duration to Transport and Return]@row * [Helper Cell]# <= 0, "", [Duration to Transport and Return]@row * [Helper Cell]#), "")

    Should work like a charm!'

    -Jon Mark

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!