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
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!