-
ODBC connector to Excel - how to share resulting workbook
Dear all: Succesfully created an Excel-based workbook where data are sourced from Smartsheet, by installing the SMartsheet ODBC data connector on a Win10 machine; created and configured a DSN; and configured said DSN with my Smartsheet user credentials and API token from my smartsheet account. Let's call me user A. The…
-
Automated App Integration Platform
Hi All, We have been using Azuqua to automate our data connection between Smartsheet and our other cloud software platforms. The Smartsheet recommendations such as Zapier are too simplistic for our needs. Since Azuqua was recently purchased, it will no longer exist in a year. Does anyone have recommendations for…
-
Future Date Issues
I've noticed that some of the dates entered, if too far in the future will revert to last century. i.e. January 5th, 2050 will work correctly if entered as 01/05/2050 but will think it's January 5th, 1950 if you enter 01/05/50 Also, once you enter the date as 01/05/2050 and it is shortened to 01/05/50, if you edit the date…
-
What does smartsheet.models.duration.Duration().elapsed do ?
Hello, My question is in the title. I've been trying to play with that but it does not seem to have any impact on duration behaviour, whether it is in the duration column or as a lag for a predecessor. Thank you
-
AvgIF(Children)
Is there a way to get an average of selected cells (all the Children of a column) only if they are not blank? I am stuck and trying to automate the functions as much as possible. Thanks a ton in advance!
-
Using smartsheets as a CRM
Hi everyone, In Smartsheets, I am trying to create a contact data base with a status trigger from a drop down menu... when "Lead Status" changes from "Lead" to "Opportunity" it triggers a bunch of actions I have set up through Zapier to set up the next steps, files, folders, etc. in Smartsheets and GSuite. Does anyone know…
-
Pop ups
I used the dashboard as a way to communicate to many within our organization, as many of you do. Recently, this week, it looks like now when anyone clicks on any link within the dashboard a new window opens rather than a new tab within the same window. Also the new Tab is not expandable. I do not have this issue on any…
-
How to empty objectValue ?
Hello, I'm using the API to change the predecessors of rows, mostly delete some entries to the predecessors field so I can then safely delete the row that was a predecessor to others. I assume it works for rows to update them with a new objectValue field that contains the same predecessors as before minus the one I want to…
-
Calculate/Compute the duration between two dates in working days
Hello, I'm back for more need in API tricks. Here's my case : because we can't edit the finish date of a task from the API, I need to find a way to make a task end at the date I want. For this, I either have the beginning date of my task, so I just need to find the duration to put in the corresponding field to have my task…
-
How do I find a smartsheet expert for hire to help build out our workspace?
I am building out a new workspace for some large marketing intergration projects. I am way over my head with smartsheets, but I have used it to complete amazing M&A sheets. I want to start intetegrating smartsheets into the operating side instead of just the due diligience side of the business.
