Invald Data type
Good afternoon,
The following formula is throwing an Invalid Data Type..
=COUNTIFS(District:District, District@row, OR(Status:Status, @cell = "pending", [Actual_PWE]:[Actual_PWE], @cell > TODAY(-30)))
The District is Text, Status is text in a drop down, and Actual_PWE is a Date which gets its value from from another cell in the same sheet and is supposed to be updated at a later time.
Not sure what is causing the error so I can correct it, any hints?
Answers
-
What logic are you wanting to accomplish?
-
Trying to collect a count of each district in the list that has a "Pending" status or a Date that meets the criteria. The expected results will get used on a different sheet to show locations with different statuses. By necessity this needs to be a sheet because the fields Actual_PWE and Status get updated manually by the user...
So I need to count Districts if the Status = "Pending" or Actual_PWE more than 30 days old.
-
The easiest way to do this would be to use a checkbox column on the source sheet with an IF/OR to check the box on every row that meets this criteria.
You can do it without this, but to avoid a double count you need to write out three separate COUNTIFS statements, add two together and then subtract the third.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!