SUMIFS criteria headache

Claybowen ✭✭✭
edited 12/09/19 in Formulas and Functions

Hello all, 

Typically, building a formula through Smartsheet doesn't give me any issues but the SUMIFS formula specifically within Smartsheet is making me pull my hair out. 

I have 3 columns that I need to use in the formula. 

-Job Code 

-Needed Position Headcount

-Building Status

I need to add the total headcount of each job code if the building has a status of either "Communicated" or "TBA".

Currently, I have the attempted formula written as: 

=SUMIFS([Job Code]:[Job Code], [Needed Position Headcount]:[Needed Position Headcount], "FACBM1" [Building Status]:[Building Status], "Communicated" OR "TBA")

"FACBM1" is the specific job code I'm wanting to add based on the building being classified as with communicated or TBA.

Could someone point me in the right direction on how to properly configure this formula?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!