Tick a checkbox when cell contains certain text

Hi,

I am wanting my checkbox to be checked if a column contains specific text (i.e. "mothers Day") on that same row.

Can someone please help?


thanks

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Hey @becs

    Are you wanting the checkbox to be checked if there is any text in the other column, or specific text? If specific text, what specific text are you looking for - or where is that information housed? Do you have a screenshot that gives an example?

    If the answer is any text, that is, not a blank cell, then the formula would look like this. Be sure to change the formula to the actual name of your text column. This formula goes in your checkbox column

    =IF([column containing the text]@row<>"", 1)

    This says if the column with text is not blank, check the box. If the text column is blank, the formula will do nothing, therefore the checkbox remains unchecked.

    Let me know if you're looking for specific text and we'll fix the formula for that. A screenshot is always helpful to the community.

    Kelly

  • BullandKhmer
    BullandKhmer ✭✭✭✭✭

    Hey, checkbox syntax is 1 for checked 0 for unchecked so in your example...


    =if([reference column]="mothers day",1,0)


    Hope that helps.


    Cheers.

  • Hi thank you for your help.

    the column is called “allocation memo” and I need check box to tick if it contains Mothers Day in the field. However, there will also be other text in the column.

    (like “Mother’s Day - ribbon”), but I need check box to only search for Mother’s Day and know if I put “Mother’s Day” it will only check the box if the cell only contains the full text.

    so I was thinking I need to use the Contains feature.


    hope that makes sense.

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    edited 11/22/21

    Hey @becs

    The CONTAINS function would show results for both Mother's Day and Mother's Day- ribbon since "Mother's Day" is contained within both textstrings. The HAS function is an exact match as well as the approach @Bulland Khmer showed above and either of these would discriminate between Mother's Day and Mother's Day- ribbon.

    =if([allocation memo]@row="mothers day",1)

    or

    =IF(HAS([allocation memo]@row, "Mother's Day"),1)

    cheers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!