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
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?
Comments
-
Hi Emma,
I think the following might be what you're after:
=IF(AND(Team1 = "Street Lighting", [Quote Successful]1), 1, 0)
Cheers,
Chris -
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)
-
Thank you so much, that worked perfectly
-
Glad I could be of help.
-
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 -
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.
-
My pleasure good sir. Just saves a few more characters in each formula.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 443 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives