Best Of

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!

Hey @Jonathan Hebert

To answer your last question - yes, that's correct and what I was wondering about.

Restricting it to people with a Smartsheet account still means anyone with a Smartsheet account could view the Form. The could create a free trial or be a part of a different plan and see your sensitive dropdown items.

I would potentially suggest adding those sensitive forms as an embedded Web Content widget in a Dashboard. Then you can either just share the Dashboard directly to specific groups/people, or use the published Dashboard link that restricts it to users in your Domain.

The embedded Form URL will only be accessible to users shared to the sheet or to the Dashboard with Admin permissions.

For your first question, you're correct - there currently isn't a way to see a list of all forms in your organization from the Admin Center. You can download a Sheet Access Report which identifies all the sheets, but not forms.

That said, you could use the Smartsheet API to List Sheets, then loop through the Sheet IDs to Get Sheets, with the parameter of include=publishedFormContainers . This would only get information for all the sheets that your specific account has access to, so if you're not shared to the sheet with the form it won't be included.

If your orgnaization has Event Reporting you could get notified every time a new form was created as well.

I hope that helps!

Genevieve

Hey @Jonathan Hebert

Thanks for waiting!

So here's what I found in my tests:

• If the default initially requires access then gets downgraded, any forms that previously required access would now allow anyone to access (default adjusted)
• However, if any form had required the logged in user to also be in the safe sharing domain, they'd still require login and for the logged in user to be on the safe sharing domain.

You noted in the first post that you have forms with sensitive dropdowns. Are those forms restricted to any Smartsheet account in general, or your safe sharing domain?