Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Using formulas with images in cells

    Overachievers
    edited 02/15/24 in Formulas and Functions

    I have a sheet that has a column with an image in each cell. In another sheet I want to do an Index(Match()) and find the image and pull it into my new sheet. I get the alt text to return. Does anyone know how to get the image to appear? Different formula? Different column type?

    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Best Answers

    • ✭✭✭✭✭
      Answer ✓

      This isn't possible, forget about it and move on with your day.

      · Share on FacebookShare on Twitter
    • Employee
      Answer ✓

      Hey @Steven Sawyer

      As @BullandKhmer mentioned, it isn't currently possible to pull an image in a cell from one sheet into another by using a formula. You could Copy a row which will copy the image, or you could use a Report to display content from two separate sheets together if that helps. Another option could be to house the image in another location (such as Google Drive) and use the Index(match to pull through the URL to that location instead.

      Can you explain a bit more about your process? We may be able to come up with a different set-up or solution to achieve your end-goal.

      Please also feel free to submit your formula feature request to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community.

      Cheers,

      Genevieve

      Need more information? 👀 | Help and Learning Center

      こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions

      · Share on FacebookShare on Twitter

    Answers

    • ✭✭✭✭✭
      Answer ✓

      This isn't possible, forget about it and move on with your day.

      · Share on FacebookShare on Twitter
    • Employee
      Answer ✓

      Hey @Steven Sawyer

      As @BullandKhmer mentioned, it isn't currently possible to pull an image in a cell from one sheet into another by using a formula. You could Copy a row which will copy the image, or you could use a Report to display content from two separate sheets together if that helps. Another option could be to house the image in another location (such as Google Drive) and use the Index(match to pull through the URL to that location instead.

      Can you explain a bit more about your process? We may be able to come up with a different set-up or solution to achieve your end-goal.

      Please also feel free to submit your formula feature request to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community.

      Cheers,

      Genevieve

      Need more information? 👀 | Help and Learning Center

      こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions

      · Share on FacebookShare on Twitter
    • Overachievers

      @BullandKhmer this is both absolutely correct, it would seem, and also completely unhelpful. But thanks for the laugh.

      · Share on FacebookShare on Twitter
    • Overachievers

      @Genevieve P. thanks for the workaround ideas. This is a one off report request. We normally get image cells linked with control center and that meets our needs. I’m going to try the copy row idea. I think that’s the winner in this case. And I’ll submit the feature request… we really should be able to get images with a formula. Thanks.

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions