-
Data Shuttle - Changing my 100% to 1%
Hello! I've created a workflow using Data Shuttle to take values from a Excel sheet and import them into my Smartsheet. I am running into an issue with any cell having a value of 100%, as they are getting inserted into Smartsheet as a 1%. All other percentages come through just fine, including with the 2 decimal point…
-
Bridge - Move Workflow to a different workspace and Trigger doesn't move?
I just created workspaces for my Bridge users and moved their workflows into their own workspaces. I noticed as I did that that their Triggers are all blank - none of their triggers moved with their workflows. That doesn't make any sense? Has anyone seen this? I definitely think this is something that needs to be fixed.…
-
Pivot App: Duplicate / Old Rows not being removed
Has anyone had an issue with old rows not being clearer out of a sheet generated by a Pivot? My only remedy so far is to delete all rows and re-run the pivot. Im thinking its a processing issue because it occurs with larger data sets.
-
Auto move sheet to another folder after few day
Hello ! i have question: we have a lot of smartsheet to capture information, but many of them have no update in more than 30 days, is there any feature that auto check these sheets, which have more than 30 days no update and move to specific folder ? Thank you
-
Extract Email Address from Contact Column
Hi, I am looking for a way to use Bridge to extract the email address from a contact and update an "Email" column in the same row for a record, when added. I assume this can be done with Java Script but I have no idea where to start!
-
Syncing Smartsheet calender with Outlook
I have been using the Smartsheet calender for awhile but we use Outlook calendar at work and I was wondering if there was a way to sync my Smartsheet calendar with my Outlook calender. Is this possible?
-
Date with Time uploading in Data Shuttle comes only with Date
Hi Everyone, I'm uploading Input excel having column value "6/1/2022 1:22:23 AM". But after uploading into SmartSheet, it comes only date "2022-06-01". I need exact format which is in my Input file. Anyone help me on this. Thanks, Sandhiya P
-
Sheet Historian - grab snapshots of a sheet and append them to a Data Table
I'd like to be able to grab copies of a sheet and append them to rows in a datatable so I can build a "historian" over time. This is the use case: I have a sheet that all our project managers use to capture the Cost To Complete (CTC) for all our projects. Each week the PMs are asked to update this sheet with their current…
-
How do you create a pivot card in Pivot App and what is it?
I am new to Smartsheet's pivot app. I normally use the Log in with Smartsheet button in the Pivot App to create a pivot table but I wanted to try the "Pivot Card - Create a Pivot card" below the normal login, however when I click on the calendar button, nothing happens. See screenshot. Can anyone help explain what a pivot…
-
Data shuttle is not running on time
Hello, We have multiple data shuttles setup to run at 5:00 am UTC and to repeat every 15 minutes with an end time of 4:00 am UTC. We effectively need these shuttles to be running every 15 minutes nonstop. For whatever reason the shuttles will stop running for no apparent reason and will not restart without us manually…
