Issue with checkboxes and requesting update


I have individual columns for assignees/contacts and a completion checkbox for each, which will go through a request update. The last column checks if all the checkboxes are full and provides a completion status. In case the assignment has less assignees than the total 10 slots, I put an =isblank(@cell)=true function for each to self-check if the field is blank, so it does not affect the completion.

However when a contact is added, the request update does not allow the option to check the Done field. Is it because of the isblank function? Is there a way for manual input to override that?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!