-
Help Desk Dashboard
Has anyone created a Dashboard that links to a Help Desk SmartSheet? I'd like to be able to have a Dashboard that shows users the status of all tickets submitted, so that multiple tickets aren't submitted for the same issue.
-
Restricting Edit/Delete to comments
I have a sheet where collaborators discuss open issues in comments column. This is great as we can now have the entire discussion around one row-wise subject in its comment box. But a problem is being faced, collaborators are able to edit/delete their previously submitted comments. And that disturbs the discussion. Weā¦
-
Created time is displaying as Pacific Time in Dashboard
I have created a dashboard and added a report to the dashboard. In the published dashboard, the "Created" time is displaying as 3 hours earlier than what the report and Smartsheet is showing. How can I get the published dashboard report to display the correct timezone as is seen in the actual report and Smartsheet?
-
Forms- Multiple guests contact informatio
Hello, We are using a form to RSVP to company events, for these events we have our team members inviting guests. The form is sent out by email to our team members and asks to provide their guest count, then we ask them to add their guest's contact info (name, company, email and phone number). The problem we have ran into,ā¦
-
Pre-populate Web form with info from Dashboard
Hi everyone, here is what I'm trying to do: I want to create a dashboard with linksĀ to web forms when doing on-site audits. These links will be different sections of items being audited. When I encounter an issue, I would click on the link, fill out the form and then keep going with my walk-through. These forms would beā¦
-
rolling up detailed project dates up to a high level gantt chart
We create a detailed Gantt chart for each project we are working internally. I'd like to roll up that data to a higher view where I can see where we stand with each project on a single Gantt chart. Is this possible?
-
Dashboards and graphing dates
Hello, I am trying to create a dashboard which includes a graph of the project planĀ baseline compared to the project's actual completion date. Attached is an image of what this looks like in excel.Ā Is there a way to create the attached graph in a SmartSheet dashboard?Ā SmartSheet is giving me an error statingĀ "Invalid Data:ā¦
-
Transferring Workspaces
I've had my intern create 168 workspaces, with each workspace containing approximately 20-50 sheets each, organized into various folders under each workspace. Each workspace also has 3-4 dashboards pulling together this information... With my intern leaving at the end of next week, what is the easiest way to bulk transferā¦
-
Widget interaction - opening in a new tab
I have created some widgets on a dashboard, that when clicked areĀ linked to a source data sheet. The issue is that these immediately open in the tab being used, meaning you have to navigate back to the dashboard. Is there a setting where you can click on an interaction widget and it will open the linked item in a new tab?
-
RYG IF Statement Help
Hello-I am working to automate a SmartSheet for my team and have a "Status" column with RYGs (Red, Yellow, Green) which are visual assists for the status of the action item. I need help; the IF statement IĀ created won't work. Here is what I need: IF the "Completed" column (based on a date entry) is populated with a date,ā¦