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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!