Formula Syntax incorrect for converting to column formula

Hello,

I have this formula to return the number of items that have not been ordered. The formula works perfectly so I want to make it a column formula but get the below error.

=COUNTM(PPE10) + COUNTM(Tooling@row) + COUNTM(Consumables@row) + COUNTM([QEW LOTO]@row) + COUNTM([Rigging/Basket Access]@row) + COUNTM(Fillers@row) + COUNTM([Raw Fiberglass]@row) + COUNTM([Core Material]@row) + COUNTM(Resin@row) + COUNTM([Adhesives/Primers]@row) + COUNTM([Vacuum Bagging Material]@row) - COUNTM([PPE Ordered]10) - COUNTM([Tooling Ordered]@row) - COUNTM([Consumables Ordered]@row) - COUNTM([QEW LOTO Ordered]@row) - COUNTM([Rigging/Basket Access Ordered]@row) - COUNTM([Fillers Ordered]@row) - COUNTM([Raw Fiberglass Ordered]@row) - COUNTM([Core Material Ordered]@row) - COUNTM([Resin Ordered]@row) - COUNTM([Adhesives/Primers Odered]@row) - COUNTM([Vacuum Bagging Material Ordered]@row)

"The column formula syntax isn't quite right"

Any thoughts? Much appreciated!

Find more posts tagged with

Accepted answers

Paul Newcome

You cannot have a specific row number in a column formula. It looks like you have a couple of cell references that are not "@row".

All comments

Paul Newcome

You cannot have a specific row number in a column formula. It looks like you have a couple of cell references that are not "@row".

Amanda MedinaIW

That was it! Thank you!

Paul Newcome

Happy to help. 👍️

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.