Add another column to formula with exception

I am having trouble with a formula, I need to add to the current formula that I want to remove any any lines that have "Sole Sourced" in the XL Submittal Type Column.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    That's odd that it would remove the blank cells from the count since blanks are not equal to "Sole Sourced". Let's try this to include them back in...

    =COUNTIFS(..............................., CONTAINS("WON", @cell)), [XL Submittal Type]:[XL Submittal Type], OR(@cell <> "Sole Sourced", @cell = ""))

    This says to include those cells that are not equal to "Sole Sourced" or are blank.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!