Managing Move/Copy Row Automation



I have an employee database stored in Smartsheet. I've connected an onboarding form to a separate sheet which gathers sensitive data. I want to move that information over to the database, but not have some of the sensitive data come over with it (other people need access to the database). I know it'll drop all information directly into the Employee Database sheet, but is there a formula that I can add to the column which would somehow wipe it once it's dropped onto the sheet?

Thank you in advance!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!