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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!