Help! Refrence using =INDEX in a drop-down single select
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.
Gregory E. Jack
Beginner Smartsheet Automations
Answers
-
Are you able to provide some screenshots for reference?
Come see me at ENGAGE 2023! I have "Happy to help 👍️" buttons!
If you can't find me roaming the floor, I will most likely be at the 10xViz Partner Booth.
-
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
Gregory E. Jack
Beginner Smartsheet Automations
-
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"
Come see me at ENGAGE 2023! I have "Happy to help 👍️" buttons!
If you can't find me roaming the floor, I will most likely be at the 10xViz Partner Booth.
-
Hi Paul,
Thanks for the insight.
Gregory E. Jack
Beginner Smartsheet Automations
Help Article Resources
Categories
Check out the Formula Handbook template!