Bananajuice2002
Member
Good morning.
I'm interested to know if it's possible to automatically change the range within a Google Sheet when a time-based trigger is set up. For instance, on the first scheduled automation, the range could be A2:B34. The following day, the trigger activates the same automation, but the data is pulled from A35:B67. This pattern continues with the range increasing each day. While creating separate workflows is an option, I'd prefer to maintain everything within a single workflow, even if it requires additional tasks. One idea I'm considering is using spreadsheet formulas to increment the range by +33 each day. Do you have any suggestions on how I might accomplish this?
I'm interested to know if it's possible to automatically change the range within a Google Sheet when a time-based trigger is set up. For instance, on the first scheduled automation, the range could be A2:B34. The following day, the trigger activates the same automation, but the data is pulled from A35:B67. This pattern continues with the range increasing each day. While creating separate workflows is an option, I'd prefer to maintain everything within a single workflow, even if it requires additional tasks. One idea I'm considering is using spreadsheet formulas to increment the range by +33 each day. Do you have any suggestions on how I might accomplish this?
