Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

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

System Admin
edited 12/09/19 in Archived 2016 Posts

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?

Comments

  • JamesR
    JamesR ✭✭✭✭✭✭
    edited 01/25/16

    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.

This discussion has been closed.