How do I know who submitted a new entry using a form.

Options

I added a system column "created by" in my sheet but when an entry is entered using a form, the created by cell populates with "web-form@smartsheet.com". Is there a way to get that cell to populate with the username of the person completing the form?

I know I can add a column "submitted by" and make that a required field in the form, but then I have two columns tracking the same thing and would need a formula to look at both cells and return the name. Seems inefficient.

Has anyone figured this one out?

Tags:

Best Answers

Answers