Unable to convert to column formula

Vinton Douglas

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

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

Jon Mark H

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