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

edited 12/09/19 in Archived 2017 Posts



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?


This discussion has been closed.