-
Trigger Outlook Calendar Event from Form Submission
I've created a form for my team to use to submit vacation requests with a manager approval and user alert workflow. I want to be able to have an Outlook calendar event added once the vacation request is approved by a manager. Any thoughts on how to achieve this?
-
Python API Library Started Throwing Error
Hi all, I've been using the Python API to update a sheet on a nightly basis. It's been working fine until a couple days ago (not sure exactly when). Now when I call smartsheet.Sheets.delete_rows(sheet_id, list_of_row_ids), I get the following json response: {"response": {"statusCode": 400, "reason": "Bad Request",…
-
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…