Countif and contains formula

Hi Help Community,

I'm trying to create a formula that counts if criteria are met in two columns: point of contact and fiscal year. The Point of Contact column is a multi-select so I think I need to use "CONTAINS" in my COUNTIF formula but I'm not sure how to do so. The Fiscal Year is a single select. Here is what I am entering which is giving UNPARSEABLE. Has anyone else done something similar?


Best Answer


  • Tamara Cook
    Tamara Cook ✭✭✭
    edited 11/07/20

    Hi @David Joyeuse,

    Thank you so much!! This worked once I put the colons between [Fiscal Year]:[Fiscal Year]. Appreciate your help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!