I've tried multiple things, even making them select a dropdown on the top row so the "modified by" for that row captures their name then using another column with contact list property with the formula "=[modified by]@row" for the remaining rows. But even this fails since in the "standard" contact list dropdown my name…
Here is what I am attempting to do. I have a sheet where people use a form to submit requests. These could come from anybody in the company (over 100,000 people) I would like to have a report, on a dashboard, where these people can come in and see the status of their request. I was hoping to create a report, filtered on…