Using CONTAINS or LEFT in a COUNTIFS
I am trying to create a helper column to flag when there are not enough safety cones in a vehicle depending on the vehicle type. For example Pickups need 6 minimum, Vans 8min and Buckets 12min. The types vary with PICKUP/FORD, PICKUP/CHEV, Pickup - Service Body, and Pickup. My first thought was to do a contains in the countifs formula, but that gave an UNPARSEABLE error.
=COUNTIFS([Safety - Cones]@row, <6, [Vehicle Type]@row, CONTAINS(Pickup, [Vehicle Type]@row))
Then I tried using a left formula.
=COUNTIFS([Safety - Cones]@row, <6, [Vehicle Type]@row, LEFT([Vehicle Type]@row, 6) = "Pickup")
Both conditions are true, but its still showing zero.
Help Article Resources
Check out the Formula Handbook template!