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!
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…