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.
Answers

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

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
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 183 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!