I keep track of dues payments for our rugby club manually in a Google Sheets workbook. I have columns headed JAN, FEB, etc and when I get notice of a dues payment I enter the amount paid in the column for the appropriate month.
I have a Zap that parses date, payer’s name and amount paid from a Gmail generated from Square. Is there a way to direct Update Spreadsheet Row to the appropriate column based on the content of the date field?
Thank you.
This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.