-
Automated Form Number Check does not allow Comma (,) as a decimal place and only a period (.)
Hello, we are a Germany based company and therefore are using a comma as the decimal place. (E.g.: 53,5% and not 53.5%) In a form i want to check if there is really a number registered before applying it. When the Number Check is activated in the form, we can only enter whole numbers or numbers with a period as the decimal…
-
Creating a metrics report - Sheet reference not working/displaying criterion
I have a metrics report I am building out for a dashboard, and have a column with a few drop-down options. I am trying to count how many of each category, and it decided it doesn't want to work. I am using the following, and this worked for the status column IE: Showing Started, Not Started, Resolved. But this column with…
-
Formatting Dashboard Metrics with Commas (,)
There are two places where I am unable to format the numbers with commas (,): first, the Sheet Summary; and second, the Dashboard metrics. It's very difficult for my dashboard visitors to interpret large numbers without commas (e.g., the amount 2320050 would be a lot easier to read as 2,320,050). Please not that the…
-
Modifying the vertical axis on graph
I have created a stacked bar graph on a dashboard from a metrics sheet, for some reason the vertical axis is showing the values as 0, 1, 1, 2. I can't work out how to change this, any ideas?
-
Charts not matching numbers
I have multiple semi-circle pie charts on a smartsheet dashboard but the chart is not matching the number. See below for example. The amounts show that funding is about 50% to goal…but the pie chart is not showing that percentage in graphic or in %. How do I fix this?
-
My formulas on my Metric sheet are calculating 0 and I'm not sure why
Hello, I am trying to create a dashboard with widgets to display our overall progression on multiple projects. I was told a Metric sheet would be best to do this. I am creating my first metric sheet but the formulas are calculating 0 and I'm not sure why. In the first section below I am wanting to add up how many projects…
-
Task totals across multiple plans & within a set timeframe
Hello! My formula skills are pretty basic so I feel like this might be a bit more than that. I am trying to calculate the number of tasks for four departments across multiple project plan sheets. I want to look at a timeframe scale of the last 3 months and the next 6 months. The four departments are: Editorial, Design,…
-
Help to set up metrics on Project Raid Logs
Hi, how do i set up a metrics sheet to gather all information from our project raid logs. We have around 70+ Project raid logs for individual projects. I would like to create one sheet to display metrics such as - How many are red, Yellow and Green, Also which dept they sit in etc.. Im not sure if reports does this but…
-
Control Center - Add Row to Metrics Sheets
Is there a way to leverage control center to add a new row to all provisioned projects metrics sheets. I have a lot of projects that are already provisioned, and I can't go in and add the rows manually.
-
Median and Mode options in Report Summary Options
We use Median for a lot of metrics as it helps to remove the outliers that can skew the data. Please add Median and Mode (if you are already updating it 😉) in the summary options for the reports.