I have a user-oriented form associated with a sheet. The sheet works as it should, but we have a specific workflow in our business where a user may need to immediately enter a nearly-identical form immediately after submitting the first form. The form has dozens of fields and the second submission is identical in all but two of the columns, so this seems like a great candidate for automation that generally follows this framework:
- When a form that meets a certain condition is submitted and the associated row is added, copy the row to the bottom of the same sheet. (The condition is if one field contains a specific dropdown value.)
- When the new row appears, find the two cells that need modification and change them.
Smartsheet doesn't appear to have a "Copy to current sheet" action, so I tried to copy the row to a new, intermediate sheet that only exists to process this condition. The row copies find, but when I try to create an automation on the intermediate sheet that's along the lines of "When a row appears, change two values" followed by "When a row is modified, copy it back to the original sheet", neither of these actions triggers.
Is there a different or better way of accomplishing this workflow?