Dashboards on rows

Hello Everyone,

I am trying to build a Dashboard, several teams in my Org. can use.

The idea behind this is as follows:

  • There is a separate sheet, which gets filled by using forms / row update.
  • Each Team fills out their row initially by using the form and then does updates on certain fields via a workflow.
  • A Dashboard accesses this row and displays these infos in a nice way and can be shared across.

My issue is, that while I can create a Dashboard that suits all my needs, it's difficult to copy it and have it just use the next row of the source data sheet without significant manual effort.

Is there an easy way around this?

Thanks a ton!