Current user metric widget

Edit Kalb

I have an evaluation form that gets filled out and results can be viewed on a dashboard. I have two, one for the submitter to see only their entries and one for the location being evaluated and the viewers see only the evaluations that are pertinent to them.

I have a sheet summary formula that counts the total visits and displays on the dashboard as a metric, but I only know how to count the total visits. Is there a way for this metric to show current user total only?

Edit Kalb

I ended up using dynamic view and that allowed me to show current user view from a published dashboard.

Erin Horiuchi Green

Hello @Edit Kalb ,

Have you tried Generate a Sheet Access Report in the Admin Center?

Must be on a Business or Enterprise plan and a System Admin to setup.

Edit Kalb

Thanks Erin. I'm on an Enterprise plan but not a System Admin. What I am hoping is for widgets like this:

which pulls from a sheet summary on the source sheet:

I would like for the dashboard widgets to show current user counts if possible.

Edit Kalb

As I'm re-reading this I'm realizing the dashboard is published therefore won't know who current user is!

Edit Kalb

I ended up using dynamic view and that allowed me to show current user view from a published dashboard.