-
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…
-
how to build an interactive dashboard
If I have a dataset looks like below: Project_ID Approval_Status P1 Approved P2 Declined P3 In approving P4 Approved is it possible to create an interactive dashboard showing the approval status of each Project ID? and Project ID put into a drop down frame on the left of the dashboard, user can select any of Project ID in…
-
Copying Workspaces with Dashboards
We have a workspace with several sheets and dashboards. We want to copy this workspace for each incident we activate for. Is there a way to have the links within each dashboard automatically update to the workspace/sheet location? Currently we have to go into each dashboard and update the links - very tedious. We are using…
-
Smartsheet Publishing
I'd like to display a view of some of my sheets within an SAP JAM group though the setup in SAP JAM requires the Smartsheet website to begin with "https://app.smartsheet.com/b/publish". Does this require publishing the page so that it is visible to users without a login or is there a workaround that anyone is aware of?
-
Locking in Colors for Charts in Dashboards (Avoiding category colors changing with dynamic data)
Hi, I am having an issue with Pie charts changing colors when data in the underlying sheets is altered. For example. If I have a pie chart with categories for task status: Not Started, In Progress, and Completed. Lets say I designate those colors Red, Yellow, and Green in the Pie Chart. If the underlying data changes so…
-
Pivot Table App: Formula + Additional Issues
Greetings, Issue 1: I have created a pivot sheet using the Pivot App within SmartSheets. Once the pivot is created I am adding additional columns to the pivot sheet, which have formulas embedded. I noticed that when adding a new row of data the formula does not propagate in the pivot sheet, I am forced to manual drag it…
