-
How to get WorkApp Analytics
Our organization uses a WorkApp to share information with others. We’re on an Enterprise plan and use Control Center to create and publish a blueprint of sheets, reports, forms, and dashboards across more than 100 projects within the WorkApp. Each project has defined users by role. I’m looking for user analytics for…
-
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
-
Metrics Pulling Help
Hi there! I have a submission sheet and a metrics sheet. I am attempting to create a formula on the metrics sheet pulling from the submission sheet. I have no trouble pulling counts, but averages are giving me some trouble.. I am able to pull the average based on 1 criteria, but no more than that. I am looking to average…
-
Attempting to create a formula to find items assigned to a contact from a drop down.
I hope my title makes sense. I work in a veterinary Setting, I am working to make some metrics for a sheet dashboard and I am trying to get a cell formula to show me how many of a category is assigned to a person. I have been able to figure out the totals per category in my sheet but now I want to be able to see it at the…
-
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…