Issue with formula in sheet summary
Hi,
I am having an issue with my formula:
=COUNTIFS([Start Date]:[Start Date], IFERROR(MONTH(@cell), 0) >= 7, Type:Type, OR(@cell = "Residence Life Event", @cell = "6 in first 6", @cell = "Welcome Back Event", [P.A.W.S (Res Life Only)]:[P.A.W.S (Res Life Only)], "Philanthropic"))
I want it to count events that are equal to or greater than a start date of July (7), if the Type is selected as either a Residence Life Event, 6 in first 6, or Welcome Back Event, and if the column P.A.W.S (Res Life Only) is selected as Philanthropic.
Answers
-
Are you getting an error message? Or is it just not pulling the data you thought?
The first issue I can see is that you can simplify things by adding a date option.
=COUNTIFS([Start Date]:[Start Date], >=Date(2020,07,07), Type:Type, OR(@cell = "Residence Life Event", @cell = "6 in first 6", @cell = "Welcome Back Event", [P.A.W.S (Res Life Only)]:[P.A.W.S (Res Life Only)], "Philanthropic"))
See if that pulls the data you were looking for. If it doesn't please post whatever error you were receiving and even a screenshot of the data with sensitive data blacked out.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!