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

  • 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

    Need more help? 👀 | Help and Learning Center

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!