Can you link to a cell and lock the link to the cell instead of the data?

For example, you are using a form and you want to display the data on dashboard that is the most relevant, i.e in the top row of a sheet? i know you can do this with reports, but i am looking at using the data metrics on a dashboard to update due to a column updating when a new form is submitted. Please let me know if anyone knows if this is possible.


Thanks

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Brendan Ginns

    If you're on a Business or Enterprise account, you can set up a Metric Widget to look at a Sheet Summary Field instead of the grid of the sheet.

    Then you can use a formula in the Sheet Summary Field to make sure the relevant data is being surfaced.

    For example, if you have a Created Date System Column in your sheet, you can use this to find the MAX date (most recent submission) and pull back data in another column from that row.

    =INDEX([Column to Return]:[Column to Return], MATCH(MAX(Created:Created), Created:Created, 0))


    Let me know if this makes sense and will work for you!

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!