INDEX(COLLECT #INVALID VALUE error

Hi! I'm trying to solve a formula issue. I'm trying to pull text (Title) from a source sheet based on 2 criteria: Slot and Score. The slot needs to equal 1.1, and the score needs to match adscore@row. Here's the formula I created:

I am getting a #INVALID VALUE error message.


Other background information:

{Title}, {Slot}, and {Score} each reference one corresponding column within the source sheet.

I have tried the Slot criterion both with and without quotation marks.

I have ensured that there is data that matches all of the criteria listed.


Help please! I've been stumped for days.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!