It would be nice if when a row is created any column with a dropdown list was able to have a default value in the cell until updated. This would help instead of having it just blank until someone updates it (such as a not started value until it is updated).
Sign in to see the current vote count, add your own vote, or leave a comment.
Hi @Sarah123
I hope you're well and safe!
Excellent idea!
Here's a possible workaround or workarounds
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
That would definitely work - thanks! I'll have to set that up.
@Sarah123
Excellent!
You're more than welcome!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
It would be nice for any type of column.
Would aslo be great to ake a default value from the Sheet summary.
For the moment I am using the Sheet Summary bit it request to use 2 column for creatig a default value.
Example in the attached file.
I tried a workflow to set status to Open if the cell is left blank. It did not kickoff. When working with support, they confirmed that this is not possible:
"The workflow will only change the cell when it recognizes the value of blank after there is some other value that has been removed. "
The point is to catch those rows where the user (me) did not enter the status. Will not be using a form to enter new rows.
So really, just provide an option to set a default setting in the properties for the column when chosing from a dropdown list.
This is actually a daily pain that needs a solution. Very simply, allow a default value to be used for any columns with column Type of have a dropdown (multi or single select), checkbox or symbol.
I know forms can be setup - this is a separate request as I am not using forms in this case. I have also worked hard to get automations setup to do this, only to be told that they would not work.
This should be a very simple request. Please up vote it!
Completely agree with Cathy, crazy that this has been an idea for years and has not been added to the roadmap. Please update!
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Since the license model has changed, the option to Share should default to VIEW, not EDIT. The View option allows less-experienced users to share that way by default, and share as Edit only when needed. This allows for less cleanup during true-up. This also prevents users from adding provisional licenses unknowingly.