-
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?
-
Generate list of recently updated sheets
I would like to have a quick readout of the five or ten most recently updated sheets from WorkspaceA or WorkspaceA --> Folder5 I can build a report that grabs all of the sheet rows by updated in the last 30 or 60 or 3000 days, but how can you get a list like: * FinanceSheetXYZ updated Yesterday by John Smith *…
-
Allow multiple sheets to be selected for the same new Alert
Allow the same new Alert to be created for several selected sheets at the same time. When starting a new project, I take a workspace and Save As New to get the sheets, reports, and folders. It would save time to be able to set up all the new Alerts on the new sheets at once. This would not be needed (for this use case, but…
