If "x", and checked box y

Emma_w4tevr

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?

Can someone please assist?

Chris McKay

Hi Emma,

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

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

Cheers,

Chris

Mike Wilday

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)

 

Emma_w4tevr

Thank you so much, that worked perfectly 

Mike Wilday

Glad I could be of help. 

Chris McKay

Hi Mike,

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

Go ahead, try it out! 

Cheers,

Chris

Mike Wilday

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. 

Chris McKay

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