If Statement for check box column

Christy Kooiman

I'm trying to reference another sheet to gather information and then update a check box column but I'm getting #INVALID DATA TYPE.

=IF(AND([Account Name]@row, {Account Name}, [Opportunity]@row, {Products Range 1}, {Product Name}, "Sample Product"), 1, 0)

Thoughts?

brianschmidt

Within the AND function, there need to be logic statements within the AND function. Assuming that you are wanting items referenced in your current sheet to meet cross-sheet references, your formula would look more like:

=IF(AND([Account Name]@row= {Account Name}, [Opportunity]@row= {Products Range 1}, {Product Name}= "Sample Product"), 1, 0)

However, I may not be understanding what you're trying to accomplish. Are you looking to update the checkbox based on a match in your other sheet? If you're able to share a screenshot of your sheets (with sensitive info blurred) and elaborate further, I'd be happy to take another look.

Hope this helps!:)