Smartsheet formula........

sahilhq

Hi, 

 

Can anyone please help me with the third part of the formula attached below? I want it to check if a column in a different sheet has a check box against the item. 

sahilhq

Oops I just realised that I didn't add a picture. See attached....

Paul Newcome

Checkboxes are true/false values.

 

So checked can be referred to as either 1 or true (no quotes).