Automating Copying Certain Columns From One Smartsheet To Another
I currently have two Smartsheets: Sheet1 and Sheet2. I am trying to automate a process where data from Sheet1:
Will automatically copy over into Sheet2 based on Request ID every hour:
However, I only want the date fields from Sheet1 in Sheet2. Is there a simplified way to go about this? I don't have a lot of experience with formulas.
Help Article Resources
Check out the Formula Handbook template!