Auto-filling columns in Smartsheet

Asha Rajesth

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?

Mike Wilday

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

Mike Wilday

Forgot to mention that you'll want to use those alongside cross sheet references to make them work.

• https://help.smartsheet.com/videos/cross-sheet-formulas
• https://www.smartsheet.com/content-center/best-practices/tips-tricks/powerful-and-flexible-cross-sheet-formulas

Andrée Starå

Hi Asha,

Formulas in contact columns. It's released now! 

https://community.smartsheet.com/announcement/announcing-formula-support-contact-columns

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting