Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    I'm trying the CONTAINS and HAS formula and neither seem to work

    ✭✭
    in Formulas and Functions

    I'm trying to count the number of times a word appears within a column range on another sheet; however, the cells I'm referencing have a dropdown so there may be more than 1 value per cell. I may be entering the formula wrong or not entering the right formula.

    image.png


    Tags:
    · Share on FacebookShare on Twitter

    Best Answer

    • ✭✭✭✭✭
      Answer ✓

      Try to use this ( Below ), I think you need to use the COUNTIF/ COUNTIFS to start things off, then use CONTAINS as follows:


      =COUNTIFS({Live Compliance Training Tracker Master Data Topic}, CONTAINS("Policy Governance", @cell))


      Ricky T

      Gov Contractor for USSF

      · Share on FacebookShare on Twitter

    Answers

    • ✭✭✭✭✭
      Answer ✓

      Try to use this ( Below ), I think you need to use the COUNTIF/ COUNTIFS to start things off, then use CONTAINS as follows:


      =COUNTIFS({Live Compliance Training Tracker Master Data Topic}, CONTAINS("Policy Governance", @cell))


      Ricky T

      Gov Contractor for USSF

      · Share on FacebookShare on Twitter
    • ✭✭

      That worked! Thank you so much. I've been trying to get it right for 3 days. I really appreciate it.

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions