Help! Refrence using =INDEX in a drop-down single select

Gregory.Jack

Hi All,

I'm new to Smartsheet, id like to use =INDEX formular reference to reference another sheet cell. when i select a single option in the drop down it will reference that cell.

Paul Newcome

Are you able to provide some screenshots for reference?

Gregory.Jack

I have one main sheet (Transport Requestion) and one contact sheet (Contact). I'd like to pull the e-Signature(image) from the contacts sheet to the main sheet(Transport Requisition) when i select the drop down option "Approved".

Image 01. (Main Sheet)

Image 02. Contact Sheet

Image 03. Referencing

How can I pull the e-Sign image form the contacts sheet to the main sheet - Transport Requisition when I select "Approved" in the drop down.

I hope I am making it clear. Thanks Paul

Paul Newcome

Unfortunately you are not going to be able to do this through formula or automation. You will need to leverage a 3rd party app or the API.

You CAN use an INDEX/MATCH to pull over data, but when pulling a cell containing the image, the formula will only output the image name as opposed to the actual image. "image_name.jpg"

Gregory.Jack

Hi Paul,

Thanks for the insight.