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

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭

    @SamprasFederer

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!