Reply To: Trying to pull Metrics from filtered reports

Inner Circle › Ask Smartsheet Guru Crew Anything › Trying to pull Metrics from filtered reports › Reply To: Trying to pull Metrics from filtered reports

April 8, 2025 at 9:43 am #627
Darren
Keymaster

    Michael,

    Bridge is certainly one to to do it. But not the only way.

    The key here is that you need to get the report data into a sheet so that you can operate on them for your metrics.

    Remember that Bridge is just an interface to use Smartsheet’s API, so with that being said anything you can do with Bridge you can do outside of Bridge, with the proper tools.

    Some ways to accomplish what you are asking for:
    1. Bridge
    2. Smartsheet DataMesh could possibly work, see this session at about the 13 minute timestamp: https://smartsheetguru.com/2025/03/07/06-mar-2025-session-datamesh-advantages-over-index-match/
    3. Report to Sheet add-on: https://smartsheetguru.com/smartsheet-report-to-sheet/
    4. Make.com : https://smartsheetguru.com/make
    5. Microsoft’s Power Automate
    6. Custom API Script
    7. Anything else that makes your life easier to work with the API like Zapier, etc.