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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Are you able to provide some screenshots for reference?

    10xViz.com

    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

  • Paul Newcome
    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"

    10xViz.com

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!