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!