-
c# Smartsheet API: Can Not Get ColumnId
I am trying to read data from Smartsheet using C# SDK. I can get sheet info but column details such as ColumnId are Null. When I run the code below, I can get sheet and its columns. Bu only column name and type are filled, other properties of columns are Null. What am I doing wrong? using System; using…
-
Custom Jira fields not in Jira Connector
Hi - I have a new Jira custom field I want to pass over to the smart sheet, but when i come to configure the connector between jira and smartsheet, the field is not available. Other jira custom fields are. What could the issue be?
-
Integrate Shortlink generator with Smartsheet
Hi all, I use Smartsheet as a master content hub where content that needs to be promoted through social media channels are submitted by multiple users through the Smartsheet webform. After the submission, the content is compiled into the Smartsheet where it is posted to the proper social channel by an admin. I was curious…
-
Live Data Connector
Just want to express my disappointment that the live data connector is only available for Business and Enterprise level accounts. There should be another option for purchase (or -- radical idea if you want to retain customers -- make it available for free) for users at other account levels. I guess I'll have to use…
-
Number Range Logic
I am trying to craft a formula that sources a numerical value in a different column and, based on that value, prints a skill level. Here's the formula: =IF([Points]1 <99, IF([Points]1 <199, “Apprentice”, IF([Points]1 <499, “Amateur”, IF([Points]1 <999, “Pro”, IF([Points]1 <1999, “Veteran”, IF([Points]1 <= 3999, “Expert”,…
-
Simplifying my formula
I would like to simplify a formula (if possible). Several items in the formula below have the same value (e.g. 25 or 10). =IF([Activity_1]1 = “JTA”, “25”, IF([Activity_1]1 = “IDW”, “25”, IF([Activity_1]1 = “Lab Builds”, “25”, IF([Activity_1]1 = “TR”, “20”, IF([Activity_1]1 = “VCDX Def”, “15”, IF([Activity_1]1 = “VCDX…
-
Backup fails with error "SSLPeerUnverifiedException"
I'm running backups daily on the smartsheet using the java backup utility. For the last month or something the backups fails. This is the error I Using properties file: C:\smartsheet\smartsheet-backup.properties ***ERROR*** SSLPeerUnverifiedException - peer not authenticated javax.net.ssl.SSLPeerUnverifiedException: peer…
-
Conditional Formatting using python API
Are there any examples of adding conditional formatting to a sheet using the python API? Google search did not turn up any. Thanks, Paul
-
Fill formula's with Zapier
Hi all, At my job, we have been using SmartSheet for a while to manage our service projects. I am now starting to use Zapier to automatically create a new line for a project in SmartSheet once an upportunity is accepted in our CRM system. However, the autofill formula functionality does not seem to work whan creating a new…
-
Is the row modified date based on the last cell that is updated?
Hello, My question is regarding the smartsheet's row modification date. The documenation only states that it's the "Time of last modification". Is that based off of the last user's cell modification? How is it determined? My goal is to get the user and date that the row was last changed. Thanks!
