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 :

Screen Shot 2022-03-25 at 11.35.09 PM.png

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

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.