Expand all | Collapse all

Formula checkbox & contains statement

  • 1.  Formula checkbox & contains statement

    Posted 03-05-2019 20:25
    I have a multi-select (lookup) field that contains several strings of text [Monthly Status Report - CLIN].  I have a second field that is a Text (lookup) field that has one string of text [CLIN].  I need a formula to check a checkbox if the text in [Monthly Status Report - CLIN] contains the text in [CLIN].  

    ***Side note:  The text in [CLIN] will only be part of the multiple strings of text found in [Monthly Status report - CLIN].  A real example is:  [Monthly Status Report - CLIN] contains 0001, 0002, 0003, 0004AA, 0005, 0006.  The text in [CLIN] contains 0001.  

    If(Contains([Monthly Status Report - CLIN],[CLIN]),true)

    But this formula is not checking the box.  Can someone please help me solve this problem?

  • 2.  RE: Formula checkbox & contains statement

    Posted 03-05-2019 20:30
    maybe try

    Contains(Totext([Monthly Status Report - CLIN]),[CLIN]),true)