Multiple Contains


I am trying to create a formula that counts the amount of instances that meet multiple criteria.

I want to count instances where the Created Date is older than two days ago, the "Service Requested" is Check-In (This is a multi check box), the Branch is Innisfil, ON and the Ticket Status is either Not Started OR Assigned

Current formula:

=COUNTIFS({Service}, $[Primary Column]$22, {Branch}, [Primary Column]@row, {Created Date}, <$Today$1, {Ticket Status}, CONTAINS($[Primary Column]$28, @cell))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!