I have created a form which captures computer name, name, and email address of the person on the smarsheet in addition to the other data they are submitting.

Is there a way I could use the formula to auto-fill name and email address for repeat users referencing the machine name either on the form or on smartsheet?



If you're using a contact column to capture the email address... not at this time. If you're just trying to capture it as text then you can do that using a vlookup comparison or an index / match combination to gather your data. 

Here is some more information on those functions.

  • Index: See the notes for examples using index/match.  
  • Vlookup