Dynamic View - Is there a way for admins to see all rows?

L Black
L Black
edited 02/04/25 in Add Ons and Integrations

I have created a dynamic view where I limited the view per a specific column. However, the sheet admins can't see any of the submissions unless they are in that column. Is there a way for sheet admins to see all of the submissions if the view access is limited to a specific column of users?

Answers

  • Isis Taylor
    Isis Taylor ✭✭✭✭✭✭
    edited 02/04/25

    We use Helper columns for this, and add the names of the admins that should see everything to that column, for every row. Then we add a Current User filter to the Dynamic View which includes the "Admin Helper". In the example below, Resource Directors and Managers only see the rows they are assigned to, while the Admin Helpers see everything because they are on every row.

    The Admin Helper would like this down the whole sheet, but as a Contact List.

    Isis Taylor

    🎓️ Core App and Project Management Certified 🏅

    🌟Peer Connect, Mobilizer, and Early Adopter Program

    Business Analyst Senior