-
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!
-
Creating a Cash Flow Model
Dear Developer I would like to know if any one be able to help me out (on a chargeable basis) to create a cashflow report that requires the consolidated view from 15 different companies. The idea is that each company has its expenses, incomes, has starting bank balances, different bank accounts, suppliers, customers etc. I…
-
Creating a Cash Flow Model
Dear Developer I would like to know if someone would be able to help me out (on a chargeable basis) to create a cashflow report that requires the consolidated view from 15 different companies. The idea is that each company has its expenses, incomes, has starting bank balances, different bank accounts, suppliers, customers…
-
Update Row background with API
Does anyone have any C# code to just find a row and update the row background color (highlight the row). I have it on another program, but because my rows have System Cells (Created By & Created Date) I have to completely rebuild the rows with the cells before I can apply the format. I was wondering if there was a quick…