Someone enters information in sheet 1 auto create row in sheet 2

Hi,

I have two sheets: “De-install sheet” and “Inventory sheet”. Is it possible to automatically create a new row in the “De-install sheet” when someone enters information (date, serial# etc…) and selects “De-Installed” from the drop-down list in the “Inventory Sheet”. I would also like the new row to be populated with the date, serial#, and an auto-populated email (already built in “De-Install sheet”).


Thanks,

Jessica

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!