-
Populating a Smartsheet from an Oracle SQL DB
We use a smartsheet to track the progress of investigations on my site. The investigation ID, description, etc. are stored on an Oracle SQL DB and I'd like to autopopulate the smartsheet with the relevant fields. Is there a way to do this? I tried Power Automate but my organization does not currently support the Smartsheet…
-
Docusign / Smartsheet | Supported Field Types
Does anyone have experience working with DocuSign "Radio Groups" and merging those fields to data inside Smartsheet? I have been utilizing the Smartsheet/DocuSign integration for several months with great results, but there are a few areas I am running into issues - this being one. I have application forms that have…
-
Leading Zeros in Data Shuttle
Hi - I'm trying to set up a way for end users to do bulk adds to our user list (vs one at a time via a form) and I have all the fields mapped in data shuttle and am getting results, except the leading zeros are being stripped away. See examples below. Since it is a data merge I can't see how I would add the ' before the…
-
Outlook Connector (Desktop Outlook 365) Tool Not Visible When Sending a Message
Greetings! I have successfully installed the Smartsheet Outlook connector for Office 365 (desktop). Upon opening a received email the Connector tool is visible and works properly. However, when I create a new email, the Connector is not visible in the ribbon: What changes do I need to make to the Connector configuration to…
-
Smartsheet and HiBob Integration
Hi there, I'm looking for a way for Smartsheet and the HRIS system HiBob to integrate, specifically regarding employees inputting holiday requests. Has anyone managed to successfully integrate and if so, please could you help me. I have briefly looked at Zapier, but I don't think it will support it. Thanks
-
Suggested or maximum payload size for Update Rows?
I've got a service that updates a sheet's rows with data from another source. It works fine on a sheet that has <5000 rows and around 19 columns, but I keep getting error 4002 whenever I'm trying the service with a sheet with >11000 rows. Is there a maximum number of row objects (and cell data) that is suggested to ensure…
-
Free Webinar: Intro to Data Shuttle
Join us on January 19th for our webinar Intro to Data Shuttle where we will be discussing how we can leverage Data Shuttle to automatically and seamlessly upload or offload data between Smartsheet and other tools you use. We will be hosting the webinar in three timezones, even if you are unable to join us live, you can…
-
Can I get alert for update request in Microsoft teams? (not as a bot, but as in team's chat)
Hi All I am trying to send an update request via microsoft teams and I successfully set up a workflow. But, the problem is the link to update the request is only coming from a bot of smartsheet rather than into the team(group) created. Under group, it is giving just a message that this user made an update. Is there any way…
-
API Questions
Hello, I'm new to Smartsheet but an old hand at data analytics. We have a group using Smartsheet to manage their project data, and they have asked to have their data merged with other in-house databases to provide consistent reporting. We are looking at using the API to set up an automated process to read their sheets and…
-
Pivot App Not Working Consistently
Hello- I have a pivot workflow set up to run hourly however it looks like the pivot app is not running consistently. It did not run an hour ago but it ran twice two hours ago. It also didn't run 7 hours ago but ran twice 8 hours ago. I have this feeding a report that is automatically distributed at 5pm everyday so it went…
