-
Google Sheets integration - automatically updating cells in GSheet when SS is updated?
Hello! I'm looking for a way to automatically update cells in Google sheets, when a cell in Smartsheet is updated. For example, if a Date changes in Smartsheet, Cell C4 in google sheets would update to the new date. Is this doable? Thank you!
-
Using Smartsheet Merge Add-on for Google Docs Problem
Hi All, I dowloaded the add- on of Google Docs with smarsheet, and I was able to connect it successfully to my relevant sheet in smartsheet, When I tried to add the relevant data to each row in my table, from each row in my smartsheet sheet it created a new table in a new page. Is there a way to embed the data from each…
-
Timeline Variance indicators
Hi, I am new to using Smartsheet and was wanted to confirm a few things timelines related: Can Smartsheet create predecessor and successor dependencies (FF, FS, SS, SF) similar to MS Project? Does Smartsheet allow for WBS elements to be created through indent / outdent similar to MS Project? Can Smartsheet allow linking to…
-
Integrate Data from other platform with API Access Token
I've never used API Access Tokens, so not familiar with how that works; however, we just recently started using a program called Samsara that helps us gather metrics on our Shared Service drivers. I'm looking for a way to integrate the Samsara data into Smartsheet. We created an API Access Token in Samsara, but how do I…
-
Third Party API connectors (IPAAS) recomendations
I'm having a hard time finding a reliable third-party integration service. I have a master sheet with a dropdown menu that is used to order a product from another department in my company. When "request" is selected in the dropdown I need a new row added to another sheet with a few details from the original row. Then after…
-
Export only new rows from form submissions to excel
I have been searching for an automated way to get this done. I have a pretty intense (for me personally) form that my coworkers use to track a number of things that I measure. I am pretty married to my sheet and have a number of automated workflows running with it as well. There are about 48 columns of data including index…
-
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…
