I have run into similar issues and I agree, it’s not without flaws. The formula editor is another example, as others have pointed out.
A good solution I have found to your particular problem is to use checkboxes in the cells. You can select them as a cell type and it converts from Boolean value text to checkbox. I also prefer that, as a user, to typing True/False.
A good solution I have found to your particular problem is to use checkboxes in the cells. You can select them as a cell type and it converts from Boolean value text to checkbox. I also prefer that, as a user, to typing True/False.