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…
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…
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…
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…
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…
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.
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 change the connection string. I do see that the "differences between smartsheet gov and…
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…
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!
Is there some way to integration Smartsheet with Survey Monkey besides export/import? Any assistance would be appreciated. Peggy
Is it possible to map a checkbox through the DocuSign integration? We have setup a sheet to automatically send and collect W-9 information using the DocuSign integration, including the sync columns feature. However, the Smartsheet does not appear to allow mapping to checkboxes, which are included on the standard W-9 (when…
Why do some users who have been added to the work app have the people with gear icon? What does it represent?
Me and my assistant are the only Smartsheet support for our company. I am trying to utilize Smartsheets for capturing issues as tickets. I have a dedicated email account for tickets. I am using the form for people to request support. But many times they will send email vs submitting the form. Is there a way to…
Help shape the future of Smartsheet. Share your ideas and feature requests.
