I have a use case where I have shared a dashboard to multiple people. All users are Smartsheet licensed. I also have a Smartsheet with the user's contact information (email) in one of its columns (named contact). This column includes one of the people who are accessing the shared dashboard.
I want to add the Smartsheet to the dashboard but instead of showing all the rows, I want to only display the rows that match the user id who is accessing the dashboard. I figure I would do this by comparing the user ID who logged in to see the dashboard against the contact columns in the Smartsheet and only display those rows that match.
Can this be done? Can I add the Smartsheet to a shared dashboard where only the user signed in can see his specific rows on the Smartsheet?
Thanks!