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!
Best Answer
-
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".
Answers
-
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".
-
That was it! Thank you!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!