Stumped on what formula to use
Hello! I struggle with formulas no matter how many times someone tries to show me how easy they can be. I hope someone here can help me figure out this solution, because I'm not sure what I'm doing wrong (or even if what I'm looking to do is possible).
I have an intake form I'm using to collect feedback from requesters "anonymously" on the job our team did with their request. I put anonymously in quotes because we know/can find (from information collected at the onset of a request that lives in another sheet) who submitted it in the first place. I find asking for feedback anonymously makes people feel like they can be more honest. I want to be able to see who submitted the feedback even though we didn't ask in the feedback form, so wanted to see if I can use a formula to pull in the requestors name that lives on one sheet into the feedback sheet (after their feedback has been submitted), using the request number as the value that need to "match" on both sheets to drop in the correct requestors name to that row/cell.
I tried using the MATCH formula, but I'm not getting any results, just errors. I tried to explain myself as best I could above, so fingers crossed someone can help! TYIA!
Best Answer
-
Youi would use an INDEX/MATCH like so:
=INDEX({Source Sheet Name Column}, MATCH([Request #]@row, {Source Sheet Request # Column}, 0))
Answers
-
Are you able to provide some screenshots with sample data for context?
-
I want this to match automatically though, every time a new feedback form is submitted and that MC # drops into the form. I figured a column formula would work here, I just don't know how to set it up. Thank you in advance, @Paul Newcome !
-
Youi would use an INDEX/MATCH like so:
=INDEX({Source Sheet Name Column}, MATCH([Request #]@row, {Source Sheet Request # Column}, 0))
-
Thank you, @Paul Newcome ! Yes! This worked! Now I know why @Sarah Val Valente says INDEX MATCH is life!
-
It is absolutely transformational for workflows ~ So curious to read more about how you're using it, @Kristen Christman. Talk soon!
-
Happy to help. 👍️
INDEX/MATCH > VLOOKUP
But if you think INDEX/MATCH is crazy, wait until you start getting into INDEX/COLLECT and/or nesting other functions within the INDEX function!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!