#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")))

Invalid Ref.PNG

Find more posts tagged with

Formulas

Comments

Mike Wilday

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

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…