Mar 12, 2021 10:44 AM
Hello there, first time on the Airtable forums. We really want to figure this out and figured someone around here may have some wisdom!
We use Airtable for our real estate business and would like to find out how we could have a small app that simply tracked # of sales we got under contract in the month, and number of sales we purchased in the month.
We track the dates of when we get a property under contract, as well as a date for when the property is purchased., in an Airtable base. We would like to use these dates to create a visual ‘counter’ of sorts that we can look at for motivation during the week ie. we can see how many properties we got under contract for the month, or purchased for the month, at a glance .
Thanks in advance for any thoughts!
Mar 12, 2021 11:25 AM
Start by adding a formula field for the [Sales]
table with this formula: IF({Date field}, DATETIME_FORMAT({Date field}, 'YYYY-MM')
.
If you want to chart sales progress month to month:
If you just want to display the number of sales from the current month:
{Month}
formula field equals the current month: IF({Date field}, IF({Month} = DATETIME_FORMAT(TODAY(), 'YYYY-MM'), "true"))
{Amount}
field of those records