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!