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.
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
Has there been an enhancement yet for graphs to update automatically when data is added?
Does anybody know if there is a connector between Smartsheet and Replicon? If there is, is this a module/capability that is inherent in the tool or would it have to be purchased? If purchased, does anybody know how much it is and how easy/hard it is to configure? We have reporting in Smartsheet (13 reports) that currently…
Hi all, I've created a data shuttle workflow that is about 98% of the way complete. I have data from an excel worksheet called 'EE Eval' I load to Google Drive and have the workflow set to take that file specifically and transfer its contents every Monday to my smartsheet called 'Employee Eval Tracking'. In testing, I…
Hello Everyone, I am recently started working on the Control Center. In my blueprint, there is one Automation workflow "Copy Row into Completed Sheet". So the Condition is if the Completed task is checked then the row moved to the Completed sheet. But when I create a new project using the control center then in this…
Help shape the future of Smartsheet. Share your ideas and feature requests.
