#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# If "x", and checked box y

Options
edited 12/09/19

Hello,

I am trying to Check box = If column 1 ="x" and if column 2 is checked = column 3 to be checked

e.g. If Column 1 contains "Street Lighting" & Quote Successful Column is checked, Street Lighting successful box is checked

I've tried the following equasions

=IF(AND(Team7 = "Street Lighting", (NOT(ISBLANK([Quote sucessful]7)))), 1, 0)

I have realised my Quote successful column is a check box so "is not blank" probably does not recognise my request

=IF(AND(Team6 = "Street Lighting", ([Quote successful]6=1,"true","false")))), 0, 1)

which i am sure i have missed something?

• ✭✭✭✭✭✭
Options

Hi Emma,

I think the following might be what you're after:

=IF(AND(Team1 = "Street Lighting", [Quote Successful]1), 1, 0)

Cheers,

Chris

• ✭✭✭✭✭✭
Options

Hi Chris, I think you're missing the value of Quote Successful = 1 (which means its checked). Emma, try the following formula which should do the trick!

=IF(And(Team1 = "Street Lighting", [Quote Successful]1 = 1), 1, 0)

• Options

Thank you so much, that worked perfectly

• ✭✭✭✭✭✭
Options

Glad I could be of help.

• ✭✭✭✭✭✭
Options

Hi Mike,

Just an FYI... Smartsheet does not need you to define a logical expression value for checkboxes.

Cheers,

Chris

• ✭✭✭✭✭✭
Options

Oh cool... so in the case of a checkbox, it won't validate if the checkbox is not checked. Interesting. Good thing to know. That is interesting. It assumes that its validates for a check. Cool. Thanks for sharing.

• ✭✭✭✭✭✭
Options

My pleasure good sir. Just saves a few more characters in each formula.

This discussion has been closed.