-
Planning : expected vs reality
Hello ! Does anybody know if how to show on the same line of the Gantt mode, the expected planning and the reality. Here attached is an example of what I need. Thank you for your help !
-
Invalid parentId
Hello, I'm currently building a rather big script using the API and I'm now running into a problem that I can't understand. I'm just trying to add rows under another one, so I specify the parentId (which I've been doing for a really long time and it has always worked until now). Response: { status: 400 Bad Request content:…
-
Auto-hiding rows
Not sure if this is possible, but I would a row to become hidden based upon the status of a drop down. If cell is blank, nothing needs to happen. If cell is "delete" or "archive", I would like the row to become hidden. Any help would be awesome.
-
Hyperlink function
Hello all, Is there a way to do the following: =if value in Column A, return hyperlink to Column B This is not a website hyperlink, this is a hyperlink to a smartsheet item. I have tried pulling hyperlinks through VLOOKUPs, nested if statements in the same sheet, etc. Manually clicking through and adding hyperlinks 1 by 1…
-
How to move multiple rows to another sheet via API
I have code in C# that moves a row from one sheet to another, but I can only get it to work when I hard code the row id in the CopyOrMoveRowDirective line. What is the syntax for passing a row id into the statement? I have tried rowm.ID in place of 80233296095108, but i get a syntax error. Here is a simplified version of…
-
Looking for Smartsheet Consulting Expertise - Charlotte NC or Atlanta GA
We are looking for a Smartsheet freelancer that can help develop additional reports and dashboards. Prefer local to Charlotte NC but open to telecommuting.
-
smartsheet API
Greetings Can someone please explain to me how APIs work ? I am not familiar with many of the technical jargons used on the SMARTSHEET API link. I need to update data on my Gantt charts automaticallu instead of manually inputting the numbers and dates. Can APIs be of any help to carry them out ? Can I somehow read and…
-
Hotkey - Ctrl "R"
Hello Smartsheets Community, I am aware the developers tried to mimic Excel's functionality as much as they were able to, but a fundamental hotkey I use in Excel is "Ctrl" + "R", which allows you to copy any cell to the right of the selected cells very quickly. When I attempt to do this in Smartsheets, my browser (Chrome)…
-
API VB EXAMPLES??
Why are there no VB examples shown in your "Smartsheet API 2.0" documentation when you have a VB example by the name of "vb-read-write-sheet"?? It would be VERY helpful if you included VB example code along with all the other languages you provide. Please tell me if you intend to add this?? Thanks David
-
Using Google Calendar shared with me
Hi, I've tried and successfully implemented the feature of publishing to Google Calendar. However, it requires that the target Google calendar be a calendar that I own, rather than one that is shared with me even though the shared calendar grants me editor rights. Is there a work around?