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.
Answers
-
Are you able to provide a screenshot of the source and target sheets with sensitive/confidential data removed, blocked, or replaced with "dummy data" as needed?
-
What about the source sheet? I am having trouble following exactly what you are trying to accomplish.
-
Sorry, there are way too many sensitive data for me to show but I think I figured it out by creating a metrics grid and put in a manual column and count quantity issues instead. Thank you.
-
Sure thing.
A lot of metrics can be automated, but it was just hard to tell exactly what data you were wanting to pull based on your description and formula provided.
Based on your use of the VLOOKUP, I would assume you are wanting to pull a single specific data point, but I don't quite understand your specific "text to search for" listed.
You can pull the Q1, Q2, etc value based on the data in the Program column, but your formula would need to be set up differently.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!