Best Of

You can, in essence. If you are using a form to populate the dropdown list you can put that value in a hidden field, and then change it after the form is submitted. 

If you're talking about when you add a new row - right from in smartsheet? Maybe not. When I create my templates for new projects in our project sheet I have the template rows already set at my default value before copying them into my sheet. So it kind of depends on how you are using them. 

Hi @Jaimy Tully,

Unfortunately there's no setting to keep zeros on the charts.

There is a workaround that involves having a value of .001 for the items, so that when they drop to 0 (or 0.001 instead), they still appear on the chart as a zero because there is a value but not enough to round up to a value of 1.

@Paul Newcome and others have provided this answer on other posts. Here's one of them, so you can see the workaround in action. Thanks Paul!

https://community.smartsheet.com/discussion/98692/dashboard-chart-shows-no-data-to-display-for-0-values

We have created user groups for different departments and have several forms with a column of users.  How do we make the drop-down on the sheet pull from a specific user group?  Right now we have to manually add/remove names from each sheets' drop down list which defeats the purpose of building user groups. 

Hi @Val W

I hope you're well and safe!

Please have a look at my post below with a method I developed to update the sheet(s) daily.

More info: 

Did 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!