Hi - How can I create this workflow in Smart sheets:
Each time a new row is added on sheet X, copy rows from sheet Y to sheet X?
The rows that are being copied over from Sheet Y are child rows and the Sheet X will have the parent row.
I would review the resources Smartsheet has on this topic!
Dan Palenchar | School of Sheets Solutions Consulting (Smartsheet Aligned Gold Partner)
Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
Smartsheet Tutorial Videos: schoolofsheets.com/youtube
If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!
PS - If you have a follow up response tag me @SoS | Dan Palenchar so I get notified of your reply!
Hi @Dan Palenchar, thanks for your response. Unfortunately, that page does not explain how to copy a sheet exactly how I am trying to do it. Do you have any other suggestions? Thanks
Copy or Move row workflows cannot be triggered by Cross-Sheet formulas, meaning we cannot add something in Sheet Y that will trigger a workflow when a new row is added in Sheet X.
What I would do is have an Alert set up when the new row is added to Sheet X. Then you can manually go into Sheet Y and check a box to trigger the workflow or copy the rows directly from within the sheet.
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.