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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!