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?
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
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 460 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives