-
Pivot table only has 2 decimal places
I'm creating a pivot table using the Pivot App from a sheet (also tried from report with the same data, and neither resolves the issue), where the values are percentages that go out to 2 decimal places. (Ex. 95.25%) The pivot table is converting the values (whether I do sum or average) to a number and only two decimal…
-
How can I track inventory from orders that come through Formstack?
We are a tourism agency. We use Formstack to collect registration details from each traveler. We integrate the information into Smartsheet to track registration numbers (and other information) and to share the information with others easily. Sometimes we use a hotel with several different room types, but with limited…
-
DocuSign Integration/Generate Document Mapping Error
Hi all, I have been added into a Dynamic View Survey where I have to "Generate Documents" via Docusign. I go through the entire process successfully up until I select the DocuSign Template I want to use. These are the steps I take below: I go into Smartsheet > click on the survey sheet in question >click on the third row >…
-
Upcoming Tableau WDC 3.0: Timeline for Smartsheet Connector Update?
Hello Smartsheet Community, I am currently facing a challenge with the upcoming deprecation of Web Data Connector (WDC) 2.0, which impacts our integration of Smartsheet with Tableau. We have been using the Smartsheet-provided WDC available here: https://tableau.smartsheet.com/tableau. As I'm looking for guidance on how…
-
Is Hide Weekends supposed to ONLY work with Monday as the week start date?
In the Calendar App, Daily View, if I select "Hide Weekends", but have "Sunday" as the start of the week, Friday and Saturday are hidden, rather than Sunday and Saturday. This seems very very odd to me.
-
Data Shuttle: Missing Rows/Entries
I have two workflows in DataShuttles set up to track costs on a monthly basis in a single sheet. One workflow is called "Current Month Cost" and the other is "Previous Month Cost." The sources are excel files from an external database that I have no control over. Every month, I take the previous month's excel file and run…
-
Needing to update Summary Sheet mapping
Hello, I am thinking this is an easy question with an easy solution. I have a Control Center blueprint where I have mapped a column incorrectly, Text instead of Contact. The data is coming from the metadata file, which is linked in from the project. Is there an easy way to change the cell linking on the Summary sheet? I…
-
Bridge - How to add 'Get Row' data into an 'Update Column' Module
Hi, I have a bridge workflow as follows; Everything works fine, but I want the last module, add comment to row, to effectively add all of the row information from above into the message.. what do I then type in this field? I tried using the object reference from above but it doesnt work, anyone got any ideas?
-
Syncing Smartsheet Calendar to Outlook - Including Times
Does anyone know how to add times to a Smartsheet item so that events will show up from Time X to Time Y? For example, see the screen shot attached. I have shared a Smartsheet to Outlook, and it's working for the event day, but I'd like it to show up with the correct time like the one does in Outlook on the left. Thanks…
-
Column formulas and Global Updates
Hi All! I've tried adding a new column from a template (with a column formula), but am getting an error. If I remove the column formula in the blueprint it works as expected. Am I doing something wrong, or has this not been updated in SCC yet? Thanks!
