Thanks for sharing this sheet @Peter !
The concept you used here gave me the idea to extend the idea further to answer the question “Am I getting all my rent checks per property every month?”
Instead of using selecting a specific reporting period, I built a sheet that shows the monthly amount in a selected category over the course of a year.
To use the sheet, select a year. Then for each row, select an Address and the Rent Category from the dropbox lists. The monthly results will appear. While this was built to check if the rent was paid, you could select any category and get the monthly results.
Here’s a link to the spreadsheet:
https://docs.google.com/spreadsheets/d/1LmF8H--6xLNbe1QyveWXqKCPyrdMNzYbYi6ZYJrctlM/template/preview
Save a copy to work with your own data. Copy the sheet into your Tiller spreadsheet and update the dropbox selectors.
If you have an idea to build upon this sheet or Peter’s original sheet, please share it with our Tiller Community.