I was helping a co-worker convert an Excel file to Smartsheet. One of the things she currently does manually is after entering new rows onto her Master file; she copies (manually) to each of the QMS Entities sheets. Now there are about 20 QMS entities. We looked at the Copy to sheet template automation, but it appears as if we can only do this for one sheet. Is there a way to do this process for multiple sheets? Or will we need to create the automation for the first sheet, then duplicate and change the title/sheet name for each of the others?
Project Analyst | Core Quality Services (QMS Transformation)