Trying to find value text


I'm generating a chart by creating a metics grid for a tracking sheet. I tried using this formula and it's giving me the response, "UNPARSEABLE." This is what I used, "=VLOOKUP( {Tracking Sheet Range 2}"Q1_2020" @cell, "Q2_2020" @cell, "Q3_2020" @cell, "Q4_2020" @cell, false)" What I'm looking for is to find the triggering quarter of each product when the issue occurred. Please let me know what I did wrong here. Thank you.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!