Can I give the RYGB Balls column "Status" a default colour when a new row is added to the sheet?

System Admin

I think my question speaks for itself.

 

The RYGB balls type has 4 coloured balls.

Which I'm using as follows.

 

Blue = "New task"

Green = "Active task"

Red = "Finished task"
Yellow = I'm not using this one.

 

So what I want is for a new row in the sheet, is for this column to automatically turn "Blue" to indicate a new task. It could also be a default colour, if thats easier. But I don't see how to do that.

 

Any ideas?

JamesR

If you are using forms to enter tasks then you can set the default in the form to Blue.

If you are not using a form then depending on the structure of your sheet you can create a master Task (Sample) at the top or bottom of the Sheet.  In the Field put the calculation ="Blue"

Add your new task in below it and it will automaticlly pick up the formulae and then drag the task to twhere you want it.  However it may be quicker to just manually change it.  This method is useful if you have a number of columns with formulae in them.  If its a one off then possibly not worth the bother.  Using the form to enter the task is a better option.