Formula Check Box

Brittanyy
Brittanyy ✭✭✭✭
edited 12/09/23 in Formulas and Functions

Hi There,

I need help with implementing "Checked" vs "unchecked" symbol into my formula. Online I saw " Checked" and "Unchecked" and that didn't work for me.



My formula : =IF([Founder?]@row = "", [First Name]@row + " " + [Last Name]@row + " is a founder of " + [Name of Company]@row + ".", IF([Founder?]@row = "", [First Name]@row + " " + [Last Name]@row + " is NOT a founder of " + [Name of Company]@row + ".", ""))


The first one is If Founder is checked

The second part is unchecked.

Tags:

Best Answers

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

    You would use the below:


    Checked:

    = 1

    (equals one)


    Unchecked:

    <> 1

    (not equal to one)

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • Toufong Vang
    Toufong Vang ✭✭✭✭✭
    Answer ✓

    In Smartsheet, the checkbox has a value of either true or false. When it is checked, it has the Boolean value of true (or the numeric equivalent of 1). It has a value of false or 0 when unchecked.

    The second/nested IF() statement is not needed.

    =IF([Founder?]@row=1, "...is founder...", "...is not founder...")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!