-
How to count total number of requests submitted?
Hi, I am trying to find a formula to count the total number of requests submitted in my grid. I want the formula to count the number of request ID's displayed. I want to use this number so I can display a metric on the dashboard. I also want to use a formula to count the number of "In Progress" requests and use this to…
-
Counting Text Color
Hello, I am working on creating metrics in our Smartsheet milestones. Currently, if a milestone was completed on-time, the date completed is turned green. If the milestone was not completed on-time, the date completed is turned red. What I would like to do is create a formula for metrics that reads the text color for how…
-
Dashboard Metrics
I'm looking to create a Metric Widget that pulls the newest data from one cell in one column that is submitted through a form. For example, we are creating a form where people can submit a bid for a car. I want to take the most current bid submitted and have that feed into a widget. I have the form set up so the data…
-
Dashboard metric widgets display is not same for data pulled from same sheet
I'm trying to figure out why the font size of the numbers are not the same for all the metrics widgets. They all pull from the same portfolio metrics sheet (shown below). Is there a way to adjust font size so On Hold and # Completed values (2, 3) are the same size as the other metrics. Appreciate your help!
-
Checkbox Used as Input in Dashboard
Has anyone ever used a checkbox input from a dashboard in a formula to include/exclude certain data in a calculation for the dashboard? I currently have a dashboard where I ask the user to input a date range that would be used to parse all of the data that could be shown in a dashboard to only the data in a date range.…
-
Can you create a chart on a dashboard with blank rows?
I have a metric that will report, month over month, new values as they are calculated and added to a sheet. There is an automation that runs each month to copy the current metric row, and place it in a historical sheet. The challenge is that the chart must be re-configured every month to include the new row. Is there any…
-
Metric Widget on Dashboard not pulling symbol anymore
Hello, I am hoping someone can help me to understand why I am getting an error now with my metric widgets in on a dashboard. Previously I was pulling a sheet summary into a metric widget that would show a "symbol" on the dashboard. Now it is showing an image error symbol and not pulling this through to the dashboard…
-
Easily Navigate to Dashboard Widget Data Source
I often have to navigate to the data source of a dashboard widget to make updates, however there is not a direct link to the data source, and sometimes the naming of the source does not make it easy or clear to find. It would be very helpful if there was a button next to data source to "Open Data Source in a New Tab" or…
-
How to make Metric Widget Align the Data?
I have a metric widget to display the number of submitted items. But it drops the value below the line of the field title. I have manipulated font size, removed the widget and re-constructed … to no avail. What am I missing? Thanks in advance!
-
Conditional Charts in the Dashboard
I would like to display a KPI if a condition is true ([boolean field] = true). Scenario: I have a helper sheet checking data entries for errors and a second helper sheet counting the errors. I would like to display a KPI on the dashboard showing the count of errors only if errors exist. The KPI then points to a report that…
