-
Smartsheet needs to have differentiation between a "text" column type and a number
When integrating data in other apps and programs, the data type is critical. Additionally, We need to be able to lock out the data type in the entry. I should not be allowed to type text into a date field or text into a number field. etc. This will enhance the reporting and BI usefulness of this tool.
-
Smart Sheet Expert User
Seeking a smart sheet expert user able to to offer consultancy services. Wishing to use the software as a database to read and report on a number of sheets.
-
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
