I created an excel file with the 12 months as my worksheets. I am adding payment information as rows. But I want to add them based on the payment month. For example, if payment is in January, the row should be added in the January worksheet, all February payments should be added in February, etc.
Adding rows in a specific worksheet based on a value
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+14
- Certified Zapier Expert
- 24171 replies
-
15 August 2023
Hi
Good question.
I’d recommend using Airtable instead of Excel/GSheets.
This will reduce the logic complexity involved in the Zap configuration.
Airtable has Views, which are segments of data. (filter, sort, group, show/hide fields, reorder fields)
More about Views: https://support.airtable.com/docs/getting-started-with-airtable-views
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.