INDEX COLLECT
Why am I not getting any answers from this formula? I have been using the same formula quite a lot and it works fine. What exactly is missing here?
The red rectangle would be my return if my formula is correct...
Thank you for your help in advance
Answers
-
The formula syntax looks ok. First thing I would check is that your range references are correct. In your formula, right click on each reference and select Edit the Reference to see where they are pointing.
(Just a note on range names - as a best practice, I try to rename ranges to show which column I'm referencing in the remote sheet. It just makes things easier to troubleshoot, especially after time has gone by. So in your case, I would rename {CKT Master IP Table Range 3} to {CKT Master IP Table Type}. )
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Hi Jeff,
Thank you so much for your advice and will follow you advice next time, having said that I have removed the IFERROR to see what my problem is...is still giving me "#INVALID REF" as my error, I have checked my reference over and over again and it looks correct. My reference sheet is 250 rows in size (would that not work)? I have had much larger size sheets and it works fine.
Thanks you for your help again.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!