Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Weekly Sales Summary

209 0
cancel
Showing results for 
Search instead for 
Did you mean: 
GHermy
4 - Data Explorer
4 - Data Explorer

Hi,

I am new to Airtable and now very tech savvy in general so I'm sorry if this is an obvious question.

I have a table with a list of my discovery calls and then I record when these turn into paying clients. I want to summarise how many sale I make per week and per month. 

When I did this in excel I created a separate sheet that had the weeks of the year listed by date and by week number. Then I set up a formula to capture all sales made in that specific week. How do I do this in Airtable?

Thanks!

1 Reply 1

Hmm, depends on your workflow really.  If it's just visual you could create a formula field that outputs the week number and year, and group by that (and you'd do the same for months)?

Screenshot 2024-09-03 at 10.10.11 AM.png

"W" & WEEKNUM({Conversion Date}) & " " & YEAR({Conversion Date})