-
Setting Scale Limit On Bar Charts
Hello Community, I would like to enquire if there is a possibility to set a limit to the axis scale information? For example I have a stacked bar chart that is showing percentage values - naturally 100% being the maximum value - yet the bar chart scale displays up to 120% (see image) Therefore, I'd like to know if I could…
-
Data storage EU
Hello! I'm afraid my question is not a new one, but I'm not giving up hope that Smartsheet is interested in expanding into Europe. Since I realized, that EU-GDPR seems to be accepted, the IT-data-security-departments at my Clients in Germany are still focused on where Smartsheet stores the data. Tha is top level of…
-
Pie/Donut Charts
I have a project summary report that gives me counts of project tasks by status in >50 project sheets. Ex: each project has summary fields for its row tasks like "Complete Count", "Not-Started Count".... My goal is to have a pie/donut chart on my dashboard to show an aggregation of counts from all of my projects. When I…
-
Bar Chart Colors based on Value
I have a bar chart (below) where i have positive and negative numbers. How can i have the bar representing the negative number to be red, while the others blue?
-
Is there a way to override existing data with a new form submission?
I have a form that is updated by users on a quarterly basis, and that data feeds into a dashboard. Is there a way to override existing data with a new form submission instead of creating a new row of data?
-
Report Gantt Chart Project Settings
I am trying to change the Gantt Chart Timeline Display in a report. The report currently has the standard display as follows: I am trying to get it to look like how I have it in the original sheet below: Whenever I try and click on project settings either nothing happens or I get the error message below: I submitted a help…
-
Can you create a bar chart using two variables?
I need to create a bar chart by quarter for Decisions and Advice (see image). I cannot seem to get the bar to show both data points in the same chart. I want to show the quarter as the Horizontal axes and then Decisions and Advice by program. Is that possible?
-
What is the maximum number of columns that can be displayed in a stacked chart widget ?
Hello, I need to compare data between 42 countries with a stacked column chart widget, but it seems we can only display 15 columns... ???
-
How to show names of issue submitters on dashboard?
I am tracking issues logged, and want to show the names of the ppl logging issues on a dashboard. I only want to show the name once, even if they've submitted multiple issues. Ideally this would appear as a list, with the name in one column and the number of issues they've logged in the column next to their name.
