-
Pivot App: Running two pivots
Hello, I want to use the Pivot app to filter two separate types of data. For example, I have a columns of primary stakeholders and secondary stakeholders. I want to be able to count the names of the primary stakeholders with their unique secondary stakeholders as well as the names of the unique primary stakeholders with…
-
Removing trailing zeros
I have an issue very much like this one but I thought I would start a new thread as that doesn't have any more answers. I've got an automation running with Smartsheet and Zapier, when a user raises a request it will put a new card in Smartsheet and ping a channel in Slack with the details. When I do that I capture the…
-
Linking Microsoft Documents to Smartsheet Dashboard / Works
Hi, I am trying to link ppt and a word document on a smartsheet dashboard and workapp. I am getting the following error how can i resolve this? Thanks!
-
WorkApps on older iPads/SmartSheet Mobile
Hello, My company is looking to roll out WorkApps to a few dozen iPads in the field, but many of these are older, and can only run SmartSheet mobile 7.6. In 7.6 I can't find WorkApps. Is it there, and if so, where? Thanks, Dennis.
-
Can I connect outlook to smartsheet?
Hi Folks, I have a specific problem where we have a central mailbox where we get mails from partners and we need to track these and respond. At the moment the tracking is done in an excel spreadsheet and my preference would be for this to be done in smartsheet. I do not know if I can create some sort of link where any…
-
Calendar App multiple sheets
In the key features for Calendar App, it says "Create a Master Calendar - Combine multiple sheets into one master calendar." I can't figure out how to pull from multiple sheets. I currently have 1 sheet that has all our projects with a date range, and then I have a second sheet where holidays, vacation, etc. are entered. I…
-
Data Shuttle upload error related to Contact List fields
I setup a Data Shuttle upload workflow to load data from a Google Sheet into Smartsheet. One of the columns of data is mapped to a Contact List column type. In the source file, the field is populated with a name (e.g Joe Soap) but the workflow doesn't run and gives an error "This column is restricted to CONTACT_LIST values…
-
Live Data Connector not working with Excel Data Model
I'm using the Live Data Connector to pull Smartsheet Data into an Excel Data Model. I then create a simple relationship in the data model. However when I pull the data into a Pivot Table Report, the relationship is not recognized/not honored. I've created this same simple report using data copied and pasted into the Excel…
-
Task spanning multiple sprints
Hello, I am using the Jira to Smartsheet connector to pull Issues into a Smartsheet. I have tasks and stories that span multiple sprints in scenarios when it is not completed in the original sprint. Jira's Sprint Report shows all the sprints that the story or task was assigned to. The Jira to Smartsheet connector is only…
-
Multi-Select Calendar
Hi! Where in the Calendar App can I select the format for the filters we need to be multi-select. What I am trying to do is have a calendar view where I can have more than one filter selected at a time to narrow down the view.