Create a dashboard KPI with number of sheets that I have?

I have 1 sheet per product. I need to count this sheets and create a metric in my dashboard. How can I do that?
The bad solution: I created another sheet with columns: name of the sheet(product A, product B,…), Responsible and date of creation, then I use this sheet as a data source for my dashboard, bu its basically rework.

Answers

  • MarceHolzhauzen
    MarceHolzhauzen ✭✭✭✭✭✭

    Hi @Geraldo P Junior

    Have you considered creating a report with all your sheets, filtering by the top row and then summarizing one of the columns?

    This in essence will count your sheets

    Marcé Holzhauzen
    Solution and Delivery Consultant with Award Winning Partner
    Want to meet?Check my availability

    Find me on:LinkedIn | YouTube

    www.prodactive.co.uk

    If this helped, help me & the SSC by accepting it and reacting w/💡insightful, ⬆️ Vote Up, and/or ❤️Awesome.