Contains Formula

RingJake ✭✭✭✭✭
edited 04/15/22 in Formulas and Functions

Hello, I am trying to make a CountIfs formula that counts across a different spreadsheet, on if the comments cell contains the words "Moved", "Delayed", "Rescheduled", "Canceled", then output the number of these delayed cells.

Having some trouble getting this to work as I think an OR statement is nested somewhere in here.

=COUNTIFS(AND({Domain}, [Domain & Area]@row, OR(CONTAINS("Canceled", {Comments}) CONTAINS("Delayed", {Comments}), CONTAINS("Moved", {Comments}), CONTAINS("Rescheduled", {Comments}))))




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!