-
Pivot App creating unwanted columns filled with 0's
I am baffled by the behavior of one of our Pivot tables. When we run the pivot, we receive unexplained columns filled with 0's. Here's the source report, a report of outstanding tasks and their End Months: We used the Pivot app to view the End Month as columns and this is the result: The problem is the first column: "2023…
-
Can datamesh pull certain data/criteria from a column?
I have a few sheets that are for different departments. Each department has a list of employees in each sheet. Some employees are in multiple departments and I was hoping to pull specific data in a column from one sheet and transfer to each department sheet based off the written department in that column.
-
Control Center Blueprint Report Point to New Workspace
Hi, I think what I'm trying to do isn't support in Control Center, but I want to verify. For a Control Center blueprint that creates a new workspace for each project, is it possible to have a report in the blueprint automatically point to the newly created workspace as a source? I don't think you can, but let me know if…
-
How do I make a direct connection from my sharepoint list to smartsheets?
I am a sharepoint user that exports information into an excel spreadsheet. How do I use that connection to export straight to a smartsheet?
-
How do I fix cell links from breaking after adding a new template sheet in Control Center?
We have a blueprint set up that has a summary section with cell links in our template sheets to navigate between the other template sheets/dashboard for our provisioned projects. We also have project metadata sheets that hold data we want to show in the summary sections. I recently had to create a new template sheet to…
-
Using a barcode scanner in Smartsheet
Hello, I am using Smartsheet for an inventory management system to monitor quantities of spare parts in a parts cage. I plan on using a handheld scanner that will be communicating with the computer. Is it possible to have this scanner communicate to Smartsheet without having to use the Smartsheet mobile app as the scanner?
-
Link to Form on a Dashboard via Control Center
We have a custom toolkit in Control Center with many sheets including an action items log, which has a form for new items. We have never included a link or other widget on our project dashboard design, but we're looking at that option now. I tried using the Shortcut widget, but when a new project is created, the link…
-
Capabilities of Global Updates
Could we use Global Updates the make the following changes to blueprint sheets: Add shared filters to the sheets Add Forms to the sheets Also, can we provision a blueprint sheet including shared filters and/or its own form (not from specific link)?
-
HubSpot/Smartsheet Integration with Control Center
Hi all, We are looking to leverage the integrations between HubSpot & Smartsheet to kickoff our new client implementation process, by way of the Control Center. I am not familiar with HubSpot but have been doing some research and will be meeting with our Sales team to learn more about HubSpot functionality. Basically, we…
-
Can SmartSheet trigger an email to case workflow via Salesforce connector?
Currently in Salesforce we have a workflow that when the rep sends an email to a specific email address from the account record in Salesforce this triggers a new onboarding case with our support team. What we would like to know is if we purchase the Salesforce Connector can we build a workflow to mirror this action to…