-
Building a Dashboard from external survey
I'm having trouble organizing either a report or a sheet for it to be data that can be read by the widgets in a dashboard. To recap: I sent out a survey to students who had the choice of attending 3 schools. The first question asks which school they attended, then all the following questions apply to each school. I want…
-
Automatically fill a sheet from a pdf or word doc
I have a word form that one of our teams needs to fill out. They then send me a pdf of the form and I need to enter the data from the form into a Smartsheet log. Is there a way to automatically scan the pdf and enter the data? I can also do it from the word form if needed. Creating the form in Smartsheet directly is not an…
-
Merged: Include column description in Report
This discussion has been merged.
-
Dashboard not showing for shared users
Hi, I've created a dashboard that displays information unique to each user. The reports included in the dashboard are filtered by Current User, and the Widgets are set to "Their own perspective." I am a licensed user and am the Owner of the dashboard, all of it's reports, and the sheets behind them. This dashboard needs to…
-
Individual Customer Report
Hello, I have a smartsheet form and sheet that I have created reports and dashboards on. The form has many submissions from customers. Many customers have made multiple submissions to the sheet. I would like a report that shows how many individual customers have submitted the form. Is there a way to create this? To note,…
-
How can I have someone see only their data on a report without access to base sheet?
I would like something where people will fill out a form about their retirement plans and that info goes to a sheet. On that form, before answering the last question, i would like them to click a link and view only their previous entries. I don't want them to see everyone's entries because it's confidential. Here's what…
-
Gant Chart - How can we track the planned versus actual LAG days?
Hello Everyone, I appreciate any help on this topic. I am starting a study of our construction efficiency looking at our last 30 projects. One of the data points we are digging into is our "planned" LAG days between certain trade partners. (LAG days are inside of our defined working days, and do not include non-working…
-
Workapps - Report Card View
Hey Team, Has anyone been able to add reports to their workapp that uses the card view? My team that I'm building this for prefer card view to visualise the data and I need to use this in a workapp. Any help would be greatly appreciated. Nadine
-
Collapse Dynamic Scope Report Dialog
When adding or editing a Dynamic Scope Report in Control Center, collapsing the list of pre-existing reports does not remain collapsed after the confirmation dialog box. Support tells me this is intentional, by design, and suggested I add a new product idea here. It would be great if collapsing these reports in Control…
-
Charts to show field averages
I have a survey - there are 10 questions that are ratings - symbols 5 stars. I need to create a graph that shows the weekly average rating for each question - prefer a bar chart. I've created a report to filter the data for the last week. I have a dashboard and see the chart widget. However, I can't figure out where to use…
