Context:
We have a Form that was created about 5 months ago for Tech Request Tickets for our company (all internal). Within our company, we all have Smartsheet accounts. We had an issue of auto-population within our form; we couldn't seem to get an email format when people were submitting requests, only the first name was showing.
Due to this, I figured out how to auto-populate by using the "Created By" column. So, they'll need to log in and submit their request, that way their email auto-populates.
Problem:
However, here's the issue. Those changes were recent, as in, last week. The previous rows of requests we have under "Created By" column are label as 'web-form@smartsheet.com'. I have over 100+ of rows with this column. Is there a way to change those in the "Created By" column to the emails of the people who submitted them?
I'm doing some automation based on that column email to send out a DocuSign form to the correspondent.
Tries:
I've tried changing the column to "Contact List" and manually change the rows to the email of correspondents, but when I change it back to "Created By", it deletes the content in them.
I've also tried having just a "Contact List" but the issue with that is I'll have to add all emails into the column (over 200) and that's not feasible, especially when we have new hires or people leaving. I don't want to keep track of such a thing lol.