-
Pivot table showing zeros
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 formula to convert the progress bar status into a numerical value that I am trying to use in my pivot table. Can…
-
How to configure direct message update requests in Microsoft Teams
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 information on how to do this in a step by step manner. All I see is direction to enable…
-
Pivot not updating formula column in child rows
Hello I am working with the pivot app and created a new column that is basically (ColumnName@row-ColumnName2@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 formula won't carry when the second section of row data (Example: Employee Name) has…
-
Smartsheet bot not generating in Gmail inbox Hangouts Chat.
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 our communication through that. I got the bot set up according to the instructions…
-
Data Uploader - Error message "Array attributes may not contain null elements:"
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) In my source attachment there are 26 columns (one is system generated so won't import anyway) and in my target sheet there are 41…
-
Filter Functionality on Calendar App has changed
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 filter to select from a drop down list with all the values in the columns.
-
Dates and months issue
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 they do something) about it but then it comes back after a month or so. This has now…
-
Automating Google MailMerge of Reports
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!
-
Survey Monkey Integration
Is there some way to integration Smartsheet with Survey Monkey besides export/import? Any assistance would be appreciated. Peggy
-
Graphs - updating automatically
Has there been an enhancement yet for graphs to update automatically when data is added?