I have a Google Sheet that has several sheets/tabs inside it.
I need to look up data, and depending on which sheet/tab the data is in, the automation continues to do different things.
Right now, I have an automation that works as follows:
Search sheet/tab #1 for the data. If data not found, router searches sheet/tab #3 for the data. If data not found, router searches sheet/tab #3 for the data. etc etc
I keep adding more sheets/tabs, and so this automation is getting longer and longer.
Is there a better way to do this? I would like to search all sheets/tabs inside of a google sheet, and depending on which sheet/tab the data is found it continues the automation in its own specific way.
I need to look up data, and depending on which sheet/tab the data is in, the automation continues to do different things.
Right now, I have an automation that works as follows:
Search sheet/tab #1 for the data. If data not found, router searches sheet/tab #3 for the data. If data not found, router searches sheet/tab #3 for the data. etc etc
I keep adding more sheets/tabs, and so this automation is getting longer and longer.
Is there a better way to do this? I would like to search all sheets/tabs inside of a google sheet, and depending on which sheet/tab the data is found it continues the automation in its own specific way.