-
Can you create Custom Functions in SS like you can in Excel with VBA programming language?
Can you create Custom Functions in SS like you can in Excel with VBA programming language?
-
Sync Error
I am getting the following error trying to sync a Google Form to a Smartsheet: Error: Start Send (create sheet): Exception: Request failed for https://api.smartsheet.com/1.1/token returned code 400. Truncated server response: {"errorCode":1071,"message":"Invalid Grant. The authorization code or refresh token provided was…
-
Automatic daily reset of checked column
I'd like to know how to automatically reset the status of checked column daily? Every day when I log in I'd to see all checked columns entries unchecked from the previous day automatically. Thanks!
-
link to another cell
It is possible to have two differents sheets, but once you update one of them in some cells the other sheet updates automatically????
-
Smart Sheet API Error
I am trying to access the sheet which I have created in smartsheet using API. I am using the following Request : https://api.smartsheet.com/sheet/{sheetId} Authorization : Bearer {Access Token} But I am getting the following error : <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> <html><head> <title>403…
-
How to handle blank cells through the API
Hi Everyone, I have a concern regarding the API. I am currently accessing the API through PHP (5.6) curl calls. The concern I have is regarding the blank cells. I have tried validating the cells through their property [VALUE] as described by the documentation. However, I am unable to properly parse through blank cells. In…
-
Key Milestones / Deliverables - Output
I am using smart sheets for project planning purposes. Each plan will have hundreds of tasks. About ten of these tasks will be what I class as a 'key milestone / deliverable'. I use another system (Salesforce) to show a graphical representation of the status of each of my projects (Tasks, issues, risks, budget, next steps,…
-
smartsheet and Enfocus Switch integration
I'm a new user and with my basic understanding I can see the potentential of Smartsheet and Switch downstream. For example the data from a form could be picked up by Switch using email notifications. My question; has anyone managed the reverse? Smartsheet accepting data from Switch and merging it with an existing sheet.…
-
Backup Reports & Templates
Hi Community, I've got backups under control... BUT what I've found from various options / systems is that the reports can't be backed up. Has anyone found a way to do this?
-
Active Reports
Has anyone out there been able to achieve this? What I would call an Active Report is as follows. A visually formatted report page that is interactive with a master sheet. The report sheet would be formatted to display a ascetically pleasing presentation of data select from the master sheet by selecting a row. This could…