Form Submissions causing duplicate names on sheet

hi there!

my department is sending out forms to various departments, and when they fill in the form and submit it, it adds the entry to the bottom of the sheet. my problem is I already have the names listed on the sheet, so their names are being added twice. is there a way to delete the name that is blank above once the person submits the form?

Answers

  • Deonizia Egan
    Deonizia Egan ✭✭✭✭

    Unfortunately no. within the same org it would be easier to use the "update request" option, or put the name in the url string instead of on the form itself, so that when they fill out the form it auto populates the name.

    this would like this…

    yourformlink?Name=persons%20name

    add this string to the end of your link replace "name" with your column name to collect the data. use %20 for any spaces in columns names or person's name.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!