Why isn't this simple formula working?

Hi, I am trying to add 3 columns together in one column. Each of the three columns below are populated by other formulas.

All of the formulas below return an #UNPARSEABLE error

=COUNT([# OF DETECTNET REQUESTS OPEN (AWAITING DECISION)]@row + [# OF DETECTNET REQUESTS PENDING (CREDIT APPROVED)]@row + [# OF DETECTNET REQUESTS PENDING (CAH TO PROCESS)

=SUM([# OF DETECTNET REQUESTS OPEN (AWAITING DECISION)]@row + [# OF DETECTNET REQUESTS PENDING (CREDIT APPROVED)]@row + [# OF DETECTNET REQUESTS PENDING (CAH TO PROCESS)

=[# OF DETECTNET REQUESTS OPEN (AWAITING DECISION)]@row + [# OF DETECTNET REQUESTS PENDING (CREDIT APPROVED)]@row + [# OF DETECTNET REQUESTS PENDING (CAH TO PROCESS)

Any suggestions would be appreciated.

Find more posts tagged with

Formulas

Accepted answers

Andrée Starå

@Melanie S

I've fixed it in your sheet!

Did it work as expected?

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

All comments

Andrée Starå

Hi @Melanie S

I hope you're well and safe!

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to 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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Melanie S

@Andrée Starå Hello there, Yes I can do that. When I just have two columns the formula will bring the sum of the two but when I add the third, is when I get the error. This formula works just fine but the second screenshot is one of the three I previously mentioned above.

Andrée Starå

@Melanie S

Strange!

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Melanie S

@Andrée Starå yep I did a bit ago. Please let me know if you need access to the linked sheet as well.

Andrée Starå

@Melanie S

I've fixed it in your sheet!

Did it work as expected?

Melanie S

@Andrée Starå Thank you so much! Fixed!!!!

Have a great rest of your week!

Andrée Starå

@Melanie S

Excellent!

You're more than welcome!

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.