Combining "blank" cells with a checkbox - notification
I am trying collectively check the box for "MIssing coating Weights" IF - one column of each coating weight is blank AND the Recheck and/or No Coating Weights Required box is NOT checked.
Thanks!
=IF([Recheck and/or No Coating Weights Required]@row, 1), "", IF(AND([1421 CTG WTS OP]@row = "", [902 CTG WTS OP]@row = "", [1402 CTG WT Top OP]@row = "", [1455 CTG WT Top OP]@row = "", [1430 CTG WT Top OP]@row = "", [Recheck and/or No Coating Weights Required]@row, 0), 1, 0))
Answers
-
Hi @Elizabeth Aird,
I think this should do the trick for you:
=IF([Recheck and/or No Coating Weights Required]@row = 1, 0, IF(AND([1421 CTG WTS OP]@row = "", [902 CTG WTS OP]@row = "", [1455 CTG WT Top OP]@row = "", [1402 CTG Top OP]@row = "", [1430 CFG WT TOP OP]@row = "", [Recheck and/or No Coating Weights Required]@row = 0), 1))
Sample output:
A few of these columns are not visible in your screenshot, but the first two appear to have slightly different names to the remaining ones, so if you are still getting an error, you may be able to see this by the colouration of the formula:
This is OK, while the below is not as the first column of the AND statement doesn't exist:
Hope this helps, but if you've any problems/questions then just post! 🙂
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!