COUNTIFS using an OR with a column hosting 2 variables
Hello,
Trying to set this formula to count 5 items using vlookup. The issue I'm having with that of the TYPE column hosting 2 distinct variables. I am not well versed but believe this needs an OR option. Curious if someone might know the best approach here.
=COUNTIFS({HUB ERP - Function}, "Data", {HUB ERP - Status}, "In Progress", {HUB ERP - Phase}, "Execute", {HUB ERP - Type}, "Task", {HUB ERP - Type}, "Activity")
Tags:
Answers
-
Maybe try this...
=COUNTIFS({HUB ERP - Function}, "Data", {HUB ERP - Status}, "In Progress", {HUB ERP - Phase}, "Execute", {HUB ERP - Type}, OR(@cell = "Task", @cell = "Activity"))
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!