Adding rows in a specific worksheet based on a value

  • 15 August 2023
  • 1 reply

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.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @MSCare 

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: