Using the CONTAINS function

Todd Smelser
Todd Smelser ✭✭✭
edited 06/05/23 in Formulas and Functions

I am attempting to add a search criteria to an existing function. The current, working function is

=SUMIFS({Total Seat Count}, {Region}, ="US East") + SUMIFS({Total Seats Archive}, {Region Archive}, ="US East")

I would like to create a new function that will specify a count with a specific unit name "VFX" found in the column "VM Name".

=SUMIFS({Total Seat Count}, {Region}, ="US East", ({VM Name}, CONTAINS("VFX", @cell)) + SUMIFS({Total Seats Archive}, {Region Archive}, ="US East") + 43)

I believe I am formatting this as given in this example on SS:

([Sold Date], CONTAINS("1:55 AM", @cell))

However, I get unparseable so can't figure out where I am going wrong.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!