What is the best way to move specific cell/column data when a specified trigger is met?
Customer example is that when information is added to the new order sheet, and marketing lead is assigned, and marketing deadline is populated, there are 5 columns of information that only need copied to the target sheet once the trigger is reached. The source sheet is 50+ columns. We don't want all columns.
We've tried Power Automate and can pull them data out. We cannot push the data back in the same way.
Would Smartsheet Data Shuttle or Bridge be better equipped to perform this? Customer prefers to stay within the Smartsheet environment as much possible.
Thank you Smartsheet Community