-
Linking to a Smartsheet functions
I've seen posts that contain links that create an action, such as "click here and a copy of that sheet will appear in your instance of Smartsheet" I cant find the OP, and cant recall if she was staff perhaps, but the link worked. Is it possible then for me to create links to actions, for instance a link from that would…
-
CORS in Ionic and third party api(Smartsheet)
I am trying to get data from smartsheet API. When I use postman and nodejs in separate server code, it works. But if I use the API inside the Ionic with HttpClient (@angular/http) it gives CORS issue with run in browser. Failed to load https://api.smartsheet.com/2.0/sheets/1235941564208899972: Response to preflight request…
-
Calling Custom APIs from Smartsheet form
Hi All, we have a simply custom API which will take as input an employees ID and return their management chain. We would like to call this API as part of a simple smartsheet form we built such that their supervisor's ID can be inserted as part of the record in the smartsheet. Are there instructions as to how to embed a…
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
Update Picklist via API
Hello, It don't see the API hook to update a Picklist. I would like to keep a set of shets and snc and thought this would be the easiest way. I thought it would be with the columns: https://smartsheet-platform.github.io/api-docs/?javascript#columns If it is not there yet, could I request that enhancement? Thanks, Brett
-
Doc u Sign Intergration
On the Smartsheet Labs sign in page for Docusign- cannot seem to login. It keeps on saying Authentication failed- tried my email and the API username. I can log into Docusign no problem on their site.
-
Not all rows are fetching from my Python Script!
I have written a script to fetch all data from a Smartsheet. i am using Smartsheet's get_sheet('sheet_id') method to fetch my Smartsheet, which has 500 rows but i am only getting exactly 300 row objects, after 300 row objects an error like this being thrown "Too large to show contents. Max items to show 300". But the…
-
Adding rows to another sheet automatically
Each time I add one more row to one sheet (Sheet A), I want to trigger the addition of 7 rows to another sheet (Sheet B) . The data in the 7 rows will be driven off of 2 sheets (Sheet A and Sheet C). Sheet C is a static lookup table. Is this possible?
-
Searching multiple sheets
Is there a way to search multiple sheets when using a filter? Frequently we have multiple properties in the same subdivision and we are looking for a specific lot/block. The filters on our sheets work great we just have to do it multiple times to search all sheets. Just looking for a time saver. Thanks for the help!
-
Product Key
I need my product Key for run powershell command. Where I can find them?
