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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!