Uncheck a Box if a cell is blank
Hi! New to smartsheet so bear with me. We have a smartsheet with a lot of users and we want to have certain columns revert to unchecked at the row (they are check box columns) if our "Supplier" column is blank. One thing though is our supplier column reverts to yellow background fill when its blank, so I hope that wont cause issues in the formula. Is it the "IFBLANK" formula I need to use even if it has a background? Not sure if Smartsheet recognizes it as blank then. Thanks for your help!
Help Article Resources
Check out the Formula Handbook template!