Premium Apps and Integrations

Archives for April 2020

Pivot table showing zerosAccepted Answer

Accepted Answer Allie Forbes 23 views 9 comments 0 points Most recent by Paul Newcome 05/01/20Premium Apps and Integrations

First post 04/30/20,Last post 05/01/20
(Image) (Image) (Image) I have three locations and different tasks associated with each location. I would like to set up a pivot table that shows me the average status of every task at each location. I set up a column that is using a formu…
Premium Apps and Integrations239
Allie Forbes
How to configure direct message update requests in Microsoft TeamsQuestion

Answered - Pending Review SoS | Dan Palenchar 21 views 2 comments 1 point Most recent by SoS | Dan Palenchar 04/30/20Premium Apps and Integrations

First post 04/29/20,Last post 04/30/20
Hi everyone, I've integrated Smartsheet with MS Teams and have successfully sent notifications to a channel. I would like to add Update Requests in Teams direct messages but am unsure how to get it to work, and am finding little useful inf…
Premium Apps and Integrations212
SoS | Dan Palenchar
Pivot not updating formula column in child rowsQuestion

Answered - Pending Review Michael Heisler 41 views 1 comment 0 points Most recent by Genevieve P 05/06/20Premium Apps and Integrations

First post 04/29/20,Last post 05/06/20
Hello I am working with the pivot app and created a new column that is basically ([email protected]@row). There are 2 sections in the row data and one section(Example: Team) will add this formula since it is the parent, but the f…
Premium Apps and Integrations411
Michael Heisler
Smartsheet bot not generating in Gmail inbox Hangouts Chat.Question

Answered - Pending Review Aaron D. 21 views 4 comments 0 points Most recent by Sean Morgan 05/01/20Premium Apps and Integrations

First post 04/28/20,Last post 05/01/20
So I'm trying to implement Smartsheets to notify our staff via Hangouts Chat. We use Gsuites for our company and rather than bombard our inbox with notifications I'm wanting to get hangouts chat to work to notify staff since we do most of…
Premium Apps and Integrations214
Aaron D.
Data Uploader - Error message "Array attributes may not contain null elements:"Question

Answered - Pending Review Paul O'Neill 112 views 4 comments 0 points Most recent by Julia C Peterson 07/23/20Premium Apps and Integrations

First post 04/28/20,Last post 07/23/20
Hi, I've been wracking my head for several hours and still cannot figure out what I am doing to receive the following error message when I run my workflow (even when using merge and replace) (Image) In my source attachment there are 26 col…
Premium Apps and Integrations1124
Paul O'Neill
Filter Functionality on Calendar App has changedQuestion

Answered - Pending Review Keegan O'Brien 21 views 2 comments 0 points Most recent by James Tanner 05/15/20Premium Apps and Integrations

First post 04/28/20,Last post 05/15/20
Hello, Was there a recent update to filter function in the calendar app? I had drop down filters for each column of the underlying sheet and they are no longer there. No when I try to recreate the filters, it doesn't allow me to set up f…
Premium Apps and Integrations212
Keegan O'Brien
Gov connection in Power BI?Accepted Answer

Accepted Answer Jamie Bedford 11 views 1 comment 0 points Most recent by Genevieve P 04/29/20Premium Apps and Integrations

First post 04/27/20,Last post 04/29/20
Is there a way to make Smartsheetgov data available in Power BI? The existing Power BI Smartsheet app/connector only seems to connect to a Smartsheet account, but not a Smartsheetgov account, and I don't see any way to customize it to cha…
Premium Apps and Integrations111
Jamie Bedford
Dates and months issueQuestion

Answered - Pending Review Risto Nykanen 31 views 3 comments 0 points Most recent by Genevieve P 05/06/20Premium Apps and Integrations

First post 04/24/20,Last post 05/06/20
Hello, Are there others or many experienceing issues that Smartsheet swaps months to dates and vica versa? I have now had this issue several times and informed SS about it. For some reason the issue goes away after letting SS know (maybe …
Premium Apps and Integrations313
Risto Nykanen
Automating Google MailMerge of ReportsQuestion

Answered - Pending Review Alex T. 12 views 7 comments 0 points Most recent by Andrée Starå 05/14/20Premium Apps and Integrations

First post 04/23/20,Last post 05/14/20
Hi all, I need to run a monthly report and perform a mail merge of that data into a google doc/pdf. Any pointers on how to perform the scheduled recurrence? Thanks!
Premium Apps and Integrations127
Alex T.
Survey Monkey IntegrationAccepted Answer

Accepted Answer Peggy P 32 views 3 comments 0 points Most recent by Andrée Starå 04/24/20Premium Apps and Integrations

First post 04/23/20,Last post 04/24/20
Is there some way to integration Smartsheet with Survey Monkey besides export/import? Any assistance would be appreciated. Peggy
Premium Apps and Integrations323
Peggy P
Graphs - updating automaticallyAccepted Answer

Accepted Answer beth_linder28141 1 view 3 comments 0 points Most recent by Genevieve P 04/26/20Premium Apps and Integrations

First post 04/23/20,Last post 04/26/20
Has there been an enhancement yet for graphs to update automatically when data is added?
Premium Apps and Integrations13
beth_linder28141
Can a form be dynamically added to a dashboard?Question

Answered - Pending Review jonnyB 21 views 1 comment 0 points Most recent by Andrée Starå 04/23/20Premium Apps and Integrations

First post 04/22/20,Last post 04/23/20
We have a group of sheets that we use as a template that we 'save as new' for new projects. So each of these projects also include a dashboard to easily access information specific to that project. The links between sheets and reports prop…
Premium Apps and Integrations211
jonnyB
Microsoft Teams Integration ProblemsQuestion

Answered - Pending Review Matt Janes 86 views 1 comment 0 points Most recent by Alejandra 04/23/20Premium Apps and Integrations

First post 04/22/20,Last post 04/23/20
We followed the steps to allow access for the integration as found on the smartsheet help pages. It was allowed, and shows success. We are able to add tabs to display our various Smartsheet items (dashboards, plans, etc.), and direct messa…
Premium Apps and Integrations861
Matt Janes
Why can't I add a sheet (editable) as a Tab in Teams anymore?Question

Answered - Pending Review Kelly S 11 views 1 comment 0 points Most recent by Andrée Starå 04/22/20Premium Apps and Integrations

First post 04/22/20,Last post 04/22/20
I've successfully added a sheet as a tab in a Team before and went to do another one today and got this message....why? (Image)
Premium Apps and Integrations111
Kelly S
Calendar App - Filters...why did you change the functionality...now...during a Pandemic?!?!?

Kyle Morgan 71 views 6 comments 0 points Most recent by Genevieve P 04/23/20Premium Apps and Integrations

First post 04/21/20,Last post 04/23/20
Smartsheet, Before I lose my mind, here... please tell me that there is (at the very least) a way for individual users to create filters without being shared to the underlying sheet. Up until this change, our users were able to access the …
Premium Apps and Integrations716
Kyle Morgan
I don't understand what functionality the Smartsheet Bot givesAccepted Answer

Accepted Answer Kelly S 11 views 3 comments 0 points Most recent by Genevieve P 04/23/20Premium Apps and Integrations

First post 04/21/20,Last post 04/23/20
Hi I have installed the Bot (shows on leftside of Teams screen) and I know how to add a tab to show a sheet and things but I really don't understand what the Bot is supposed to do for me (the thing showing on the left side of my Teams scre…
Premium Apps and Integrations113
Kelly S
Power BI Desktop Refresh IssueQuestion

Answered - Pending Review Joseph 33 views 1 comment 0 points Most recent by Alejandra 04/23/20Premium Apps and Integrations

First post 04/20/20,Last post 04/23/20
I got Power BI Desktop to load graphics into a dashboard. Only problem is that I have to login too often. Is there a way to keep the graphs always open in the dashboard?
Premium Apps and Integrations331
Joseph
Calendar App - Displaying full nameQuestion

Answered - Pending Review Mark Ryan 41 views 1 comment 0 points Most recent by Genevieve P 04/22/20Premium Apps and Integrations

First post 04/20/20,Last post 04/22/20
I've noticed that there is different behaviour with how the resource infomration is displayed if the Assigned To column in the sheet is set to allow multiple assignments, or one resource only. When allowing multiple resources to be selecte…
Premium Apps and Integrations411
Mark Ryan
Jira - Smartsheet Connector: Updating issue status in Smartsheet, not syncing to JiraQuestion

Answered - Pending Review Jordan McCombs 31 views 1 comment 0 points Most recent by Jordan McCombs 04/17/20Premium Apps and Integrations

First post 04/17/20,Last post 04/17/20
Hello, We have a bidirectional sync set up between our Jira instance and a Smartsheet. When we make changes to the status on the Jira ticket, they do appear correctly on the Smartsheet. That's with the issue status being mapped to a text/n…
Premium Apps and Integrations311
Jordan McCombs
MSFT Power Automate (Formerly Flow) ConnectorQuestion

Answered - Pending Review Mark Salamon 218 views 2 comments 1 point Most recent by Mark Salamon 04/22/20Premium Apps and Integrations

First post 04/17/20,Last post 04/22/20
I have been testing out the connector that SmartSheet has built for Power Automate (formerly Flow): https://docs.microsoft.com/en-us/connectors/smartsheet/. I am using it to insert a new row into a sheet, triggered when an email is recei…
Premium Apps and Integrations2182
Mark Salamon
Salesforce to Smartsheet ConnectorQuestion

Answered - Pending Review Ashley Sabo 41 views 1 comment 0 points Most recent by Nathan Lloyd 04/20/20Premium Apps and Integrations

First post 04/17/20,Last post 04/20/20
Does anyone know if there is a way to export all workflows to identify which Salesforce fields are being used in the connector? Basically a map that identifies all the fields in Salesforce that Smartsheet touches and if its read only or re…
Premium Apps and Integrations411
Ashley Sabo
Joget DX, dynamic drop downs or assigning effort hours to wbs elementsQuestion

Answered - Pending Review Risto Nykanen 32 views 3 comments 0 points Most recent by Andrée Starå 04/19/20Premium Apps and Integrations

First post 04/16/20,Last post 04/19/20
Hello, Has anyone experience on Joget DX platform/form builder and integrated it with Smartsheet? I would be interested in hearing if it is easy to apply or a doable solution or if there are more suitable options. After viewing Joget a bi…
Premium Apps and Integrations323
Risto Nykanen
Why Calendar App is not Displaying properly?Question

Answered - Pending Review jpagan03101416 52 views 3 comments 0 points Most recent by Neil Spencer 07/03/20Premium Apps and Integrations

First post 04/16/20,Last post 07/03/20
For some reason the calendar App in web or is not working correctly. I have attached a screenshot of the web and a PDF export (PDF is working how is supposed to) Web Version (Image) PDF version (Image)
Premium Apps and Integrations523
jpagan03101416
Read only blank cellsQuestion

Answered - Pending Review Yashwant Singh 11 views 1 comment 0 points Most recent by Genevieve P 04/16/20Premium Apps and Integrations

First post 04/15/20,Last post 04/16/20
In dynamic view details panel, it's possible to restrict edit option for customer which year is blank.. (Image)
Premium Apps and Integrations111
Yashwant Singh
PowerBIAccepted Answer

Accepted Answer Tripp Boren 21 views 3 comments 0 points Most recent by Genevieve P 04/19/20Premium Apps and Integrations

First post 04/14/20,Last post 04/19/20
Is there a best practice for adding a column or columns in a smartsheet that is linked to a power bi without it blowing up the power bi refresh?
Premium Apps and Integrations213
Tripp Boren
Calendar App - filter disappeared?Accepted Answer

Accepted Answer Sami Vattula 41 views 3 comments 0 points Most recent by Genevieve P 04/22/20Premium Apps and Integrations

First post 04/14/20,Last post 04/22/20
For some reason, I no longer see the filter for my calendar in the Calendar App. I was able to see it still yesterday and to filter columns based on my settings, but now the "funnel" icon is no longer visible and replaced by &quo…
Premium Apps and Integrations413
Sami Vattula
JIRA smartsheet connector with FormulasQuestion

Answered - Pending Review Evan Summerville 52 views 3 comments 0 points Most recent by Evan Summerville 04/28/20Premium Apps and Integrations

First post 04/13/20,Last post 04/28/20
Hello, I'm currently attempting streamline work status changes with Smartsheets as they are integrated with my JIRA instance via cloud connector. The way we currently run our projects within JIRA (that are synced to Smartsheets) is by crea…
Premium Apps and Integrations523
Evan Summerville
Is Live Data Connector compatible with Windows Server 2019 & 2020?Question

Answered - Pending Review CovidPlasmaSaveALife 31 views 3 comments 0 points Most recent by Alejandra 04/29/20Premium Apps and Integrations

First post 04/13/20,Last post 04/29/20
Hi, docs say only through Win Server 2012, hoping documentation out of date. Thanks
Premium Apps and Integrations313
CovidPlasmaSaveALife
Percentage in Dynamic ViewQuestion

Answered - Pending Review Silvia Rangel 21 views 2 comments 0 points Most recent by Silvia Rangel 04/14/20Premium Apps and Integrations

First post 04/13/20,Last post 04/14/20
Help! I am using a percentage complete to trigger a Field Logic, but l select 100% (which is the trigger) and save, the field shows as 1 - Any ideas why??? (Image) (Image) Thanks!
Premium Apps and Integrations212
Silvia Rangel
Microsoft Forms and smartsheet column typesQuestion

Answered - Pending Review Julia C Peterson 41 views 1 comment 0 points Most recent by Paul Newcome 04/10/20Premium Apps and Integrations

First post 04/10/20,Last post 04/10/20
I used to use Formstack but my company is switching over to Microsoft Forms. I'm having an issue where I get a Microsoft Flow error message when I try to map the Forms Timestamp to a smartsheet column that is "Date" format. This …
Premium Apps and Integrations411
Julia C Peterson

Premium Apps and Integrations

Premium Apps and Integrations

Discussion List