Default cell values when editing new row non-programmatically in Google Sheets

Question

I have a spreadsheet that I maintain manually, whenever a new line is edited I would like the columns in the row to have a default value, such as True or False or some other category value.

I know about using e.g. =B2:B if another column has a formula referencing B but I am just talking about setting a default value per cell. Is there a smart way of achieving this?

Answer 1

Try to use this formula:

=IF(LEN($A2)<>0,"Yes","-")

or

=IF(LEN($A2)<>0,"No","-")

But you may need to drag-down the formula manually if you will use this. That is why I decided to set the cell value to "-" if ever column A is empty so that you will be aware until which row did you copied the formula.

Sample Sheet: