#INVALID REF
Below formula works fine in some cells but in others it says invalid ref in the same column.
What could be the issue?
=IF([JC Number]11 = "", "", COUNTIFS({JC number}, [JC Number]11, {SCT}, "Yes", {Trucks Status}, OR({Truck Status} = "Road Freight - Moving Loaded", {Truck Status} = "Road Freight - Import Clearance", {Truck Status} = "Road Freight - RIT Clearance", {Truck Status} = "Road Freight - Export Clearance", {Truck Status} = "Road Freight - Waiting to Offload", {Truck Status} = "Road Freight - Delivered", {Truck Status} = "Road Freight - Accident", {Truck Status} = "Road Freight - Broken down", {Truck Status} = "Road Freight - Waiting for Convoy", {Truck Status} = "Road Freight - Waiting for Escort", {Truck Status} = "Road Freight - Waiting for Security to Improve")))
Comments
-
Invalid Ref refers to a sheet reference in curly brackets that doesn't exist. I would check to make sure your cross sheet references are accurate.
https://help.smartsheet.com/articles/2476176-formula-error-messages#invalidref
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 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!