Is there a way to automatically duplicate a row once it is added from a form submission based on a cell value in that row?
The most immediate solution that comes to mind is creating an automation rule to copy the row to another sheet, and then an automation rule on the second sheet that moves the copied row back to the first sheet.
Caveat: If you have formulas in your fields in the first sheet, they won't transfer to the second sheet, only the cell values transfer; so when the copied row moves back to the first sheet, it won't have any formulas.
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
I am faced with the same challenge for my needs. If a specific column is "yes" than the row data (until the Yes) needs top be copied into the next row. I have found information regarding copying into a different sheet, but like you, my needs require copying or moving only to another sheet. I even looked at building my automation from scratch and that was not an option.
Project Analyst | Core Quality Services (QMS Transformation)
EAP | Mobilizer | Automagician | Superstar | Community Champion
I'm sure this is super simple but myself and a colleague could not figure it out. I have some very simple data I need graphed for a project: Not Started, In Progress, Complete and then % Complete using the total. The pie chart for the Not Started etc. comes out correct: But when I ask it to graph just % complete, it does…
Hello, I am working on a training log for our company. I am trying to get the status color to turn green if training is completed, yellow if it is due in the future, and red if it is incomplete. I keep getting an incorrect argument. I had it working correctly when I was just doing red and green, but I really need that go…
Hi, I have a sheet that collects data from several forms. I have an automation that kicks off every Thursday at 5:00 AM to move all the data in the sheet to an archive sheet, I have another automation that is supposed to kick off at 8:00 on Thursday to check if the column is blank, then alert someone via an email to enter…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.