VLOOKUP for attachment on another sheet

12/26/18 Edited 12/09/19

Smart sheet enables the user to upload attachments, which is useful. So what I do for my workflow is I have a full sheet dedicated for part number and part information, so when I type in a part number on the work order sheet it auto-fills the rest of the information such as description, assigned person etc using the formula "=IFERROR(VLOOKUP([email protected], {Products Range 4}, 2, false), "Invalid Part Number")" from the Products sheet.

 

I have figured out how to do this for everything EXEMPT the attachments. The attachments are drawings and instructions for each part on the work order sheet. Is there any way I can reference the attachment that is also on the products sheet?

 

Kind Regards,

Comments

  • Mike WildayMike Wilday ✭✭✭✭✭

    Have you considered storing the attachments somewhere other than Smartsheet? I do not believe that you can vlookup attachments from another sheet within a new one using cross-references. 

  • Mike WildayMike Wilday ✭✭✭✭✭

    The goal would be to add the reference or link to the "other location" in the smartsheet, and then you can vlookup that reference. 

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Cody,

    Unfortunately, it's not possible at the moment, but it's a great idea!

    Please submit an Enhancement Request when you have a moment.

    Mikes suggestion would be my recommendation as well.

    Happy Holidays & Happy New Year!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.