Package condition vlookup
Hi, I'm trying to help our loading dock out by taking the cells they would normally just fill out, make it a form that is submitted per package. At the end of the day, look at the summary and send an email to the recipient based on the storage condition. The three storage conditions are 4C, -20C, and -80C, on a connected sheet I have a list of the recipients different fridges based on the different conditions. Is it possible to have a location cell, populate based on the recipient and the storage condition? This is what I've come up with
=IF([StorageConditions]1, = "4c"(true)VLO
OKUP(Recipient1, {Freezerlocation Range 2}, 2, false)
The Vlookup will work, but the if statement doesn't.
Thank you for your help!
Answers
-
Try something along the lines of...
=INDEX(COLLECT({Other Sheet Location Column}, {Other Sheet Recipient Column}, Recipient@row, {Other Sheet Conditions Column}, StorageConditions@row), 1)
-
Hi Paul, thank you for the help. I'm pretty new to smartsheets, This is what the location column would be referencing. Would it be better to make individual sheets for each
storage conditions and their corresponding locations?
-
Ok. Try this instead then...
=INDEX({Other Sheet [4c]:[-80] Columns}, MATCH(Recipient@row, {Other Sheet Name Column}, 0), IF(StorageConditions@row = "4C", 1, IF(StorageConditions@row = "-20", 2, 3)))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!