Count "Booked" status from last week
=COUNTIFS({Activity Log - SaaS Range Status 8}, "Booked", {Activity Log - SaaS Range Date}, WEEKNUMBER(@cell ) = WEEKNUMBER(TODAY()) - 1)
=SUMIFS({Activity Log - SaaS Range Amount}, {Activity Log - SaaS Range Status2}, "booked", {Activity Log - SaaS Range Date2}, WEEKNUMBER(@cell ) = WEEKNUMBER(TODAY()) - 1)
Kindly help to fix this formula as I'm not getting the correct data. I want to get the number of Booked Orders and Amount By weekly (ex: from Oct Oct 14 Monday to 20 Sunday). I really appreciate your help.
Answers
-
Hello @Jezzele
Could you provide a screenshot of the data you're working on? You can use dummy data to help us better understand what you're trying to accomplish.
che
-
Hi @che.rabajante
-
Those formulas are written out properly. Have you applied a filter to the source data that replicated your range/criteria sets?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 150 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!