If Statement for check box column

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?

Answers

  • brianschmidt
    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!:)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!