Invald Data type

Matthew 5
Matthew 5 ✭✭
edited 10/04/23 in Formulas and Functions

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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • @Paul Newcome


    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.



  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!