Cross sheet references

Is there a way to reference a report summary (count) in another sheet or dashboard?


Thanks!

Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    Hi @deb_63_hydracor

    The Summary fields in a Report cannot be used as a cell-link or referenced in a cross-sheet formula reference. However you can place these details into a Dashboard in a few different ways!

    You can either use a Report Widget to embed the numbers into the Dashboard (only as the Summary or also with the rows beneath), or you could use the data to source a Chart Widget.

    Cheers,

    Genevieve

    Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.

Answers

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    Hi @deb_63_hydracor

    The Summary fields in a Report cannot be used as a cell-link or referenced in a cross-sheet formula reference. However you can place these details into a Dashboard in a few different ways!

    You can either use a Report Widget to embed the numbers into the Dashboard (only as the Summary or also with the rows beneath), or you could use the data to source a Chart Widget.

    Cheers,

    Genevieve

    Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!