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(Part@row, {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,