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

0
votes

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.

enter image description here

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?

2
google-sheets
share a copy of your sheet with example output - player0
Does this example of file above help explain? docs.google.com/spreadsheets/d/… - boardtc
sheet is private - player0
sorry, fixed that - boardtc

2 Answers

1
votes

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: enter image description here

0
votes

see:

=ARRAYFORMULA(IF(A2:A="",,{"yes", "no", "no", "yes"}))

enter image description here