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
 Smartsheet Customer Resources
 63.1K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 450 Show & Tell
 30 Member Spotlight
 1 SmartStories
 289 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!