trying to convert a row to column formula using IFERROR

using NETDAYS to calculate days between dates, and an IFERROR to have Blank populated. This works in the row just fine, When I try to convert to a column formula, I add @row to the cell and it becomes #UNPARSABLE. Before adding @ROW tried to convert to column formula and get the following. Help!!!!

formula that is working in row format =IFERROR(NETDAYS([Potential start date]1, [Screening_Date]1), "Blank")

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul H

Can you post your formula that doesn't work?

This should work:

=IFERROR(NETDAYS([Screening Date]@row, [Potential Start Date]@row), "Blank")

MilesTHD

Thank you for your quick response. This works as a row formula in the cell -

(Works) =IFERROR(NETDAYS([Potential start date]1, [Screening_Date]1), "Open")

And

If I change it to -

(Fails) =IFERROR(NETDAYS([Potential start date]@1, [Screening_Date]@1), "Open")

I first get a #UNPARSABLE in the cell and then i try to convert i get the same error message.

when i add the @ is when it seems to blow up, have I missed a step somewhere?

I have seven columns that all use a similar version of this formula, the names are the difference

Andrée Starå

Hi @MilesTHD

I hope you're well and safe!

Try something like this.

=IFERROR(NETDAYS([Potential start date]@row, [Screening_Date]@row), "Open")

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

MilesTHD

Thank you it worked. what did i do wroong?

Andrée Starå

@MilesTHD

Excellent!

Happy to help!

The error was that you had @1 instead of @row.

=IFERROR(NETDAYS([Potential start date]@1, [Screening_Date]@1), "Open")

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Jon_H2020

I'm getting the same syntax error for this formula:

=IFERROR(((TODAY@row - DOB@row) / 30.41) / 12),"")

Not sure why it won't let me convert it to a column formula.

This formula works as a column formula:

=((TODAY@row - DOB@row) / 30.41) / 12

Any ideas?

Andrée Starå

Hi @Jon_H2020

I hope you're well and safe!

Try something like this.

=IFERROR((TODAY@row - DOB@row) / 30.41 / 12, "")

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.