API/Developers
Discussion List
-
Automatic creation of sheetsIn API & DevelopersHi, I'm wondering if there is a way to automatically create a tracker from a template when a row is added to a master sheet? So, I'd have a form add rows to a master sheet, then I'd like that to automatically start an individual tracker t…
-
Updating rows with multi_contact cell?In API & DevelopersHello, I'm using the Python API to update some rows as follows: copy cell values in specific columns from an old row, and append these to an update request as cells in the respective column for a new row. This works for all but a contact c…
-
API Access to Column FormulasIn API & DevelopersI have been trying to understand how to handle column formulas and all I can see is that you have error messages to let us know that we can modify cells in columns with column formulas but there is no column attribute to indicate that a co…
-
Card View - Conditional FormattingIn Using SmartsheetHi all (Andre you about? haha) I am trying to conditional format on the card view, in terms of striking through the Primary Text (Task Name) when the % Complete column = 100% This works on the grid or gantt view however does not carry ove…
-
Building A Test Package In SQL Dev That Writes To A SmartsheetIn API & DevelopersHello, I am attempting to build a package in SQL Dev that takes data from a table in SQL Server and inserts it into a Smartsheet. For example, I have three lines of data in a table in SQL Server that I need to have added to a Smartsheet ta…
-
API Load Error with Python ExecutableIn API & DevelopersI have created a python script in PyCharm, the file has been running with no issues. I converted the file to .exe using PyInstaller and auto-py-to-exe but with both methods I receive the following error after running the .exe: "Impor…
-
Rolling up multiple projects onto a dashboardIn Using SmartsheetIs there a way to roll up the critical pathways and key milestones for multiple projects / smartsheets into one dashboard?
-
Can we plot address info from Smartsheet live on to google maps?In API & DevelopersLooking to create a live map (Ideally google maps) that updates with Smartsheet address info (Postcodes)
-
Search rows API after create rows API from Power Automate/Flow returns incorrect row object ID'sIn API & DevelopersI'm attempting to have a flow in Microsoft Power Automate/Flow create rows in a Smartsheet sheet and update a field once an approval outcome is present. The first part works with no problem - rows are created with a value in one column to …
-
HYPERLINK APIIn API & DevelopersWe have been using HYPERLINK("http://website.ws/links", "Click Here") in both excel and google spreadsheet, and since we need jotforms integration for client our current links in smartsheet is very long and creating hyp…