-
OPen access to access data directly to google docs (spreadsheet) without exporting first
I have feature request on access of data to googlesheets...I want to access smartsheets directly from my own google sheets so that i can build my own fully custom dashboard using google sheets but from that i would need to be able poll the project data directly from smartsheets. I would like that.
-
Jira performance issues when connecting 50 + projects (and temp solution)
Hello, We did experienced some serious performance issues in Jira after connecting 50+ project to Smartsheet. I did find the problem and can be fixed by hand. I allready raised this issue with smartsheet hope they can add a fix soon. Problem explained: When adding a workflow with the smartsheet workflow manager, the tool…
-
Transferring information from one sheet to another when checkbox checked
I have a system whereby people are able to report issues by completing a form through smartsheet. Once the issues are clarified or resolved, I want to release certain information to other parties, but not all of it. I would like to be able to check a checkbox that says "release" and this will then trigger a transfer of…
-
DSN architecture mismatch
When I try to follow the ODBC instructions for the 64 bit Live Data Connector to use it with Microsoft Excel or Access 2016 and the Smartsheet DSN I set up in Windows 10 using an API access token, I get the following error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the…
-
Notifications
Hi Guys, Im trying to set auto Notfication I have a Project sheet with Date type of coulmn called "Last Updated" I have another text Column Called balance Due I want to Create a notification if Balance due is higher then 0.00 Send Reminder 2 days after the date in the last updated Column and if not do able with smartsheets…
-
dependent actions
Can actions be made to be dependent upon another action? For example - Can I trigger an action to occur when a specific button is pushed and have the action affect a specific field in the same row as the button ? - specifically , I am wondering if I can populate a field with the current date (say field 3) when the button…
-
Assembly + Inventory Tracking
I've created a smartsheet to track every unit we sell of one of our particular product lines. The sheet includes the unit's serial number, model number, client name, client PO number, internal 'project number', current location of unit (Ex: "On order", "Johnny's bench", "Software dept.", "Warehouse", "Shipped - En Route",…
-
30-Day Prompt
Hello, I'm needing to create a sheet where a task has a start date of say, 11/1/2017, and then I need to be reminded of something 30 days from the start date, 11/31/2017. Can someone help with the formula for that? (Column A would be "Task" and Column B would be "Start Date". I'd like Column C to be "Action Date." There's…
-
API - Bulk Operations Documentation
Does anyone have or know where I can get some information or an example on the Bulk Operations for the API? I am writing an app that outputs data to SmartSheet, however it seems to be a bit quick for SS as it throws errors saying it's already being updated by another process. It only succeeds if I put in a 300 ms delay. So…
-
Project Parent Hierarchy not shown in PowerBI
Hi there, I am trying to connect Smartsheet and PowerBI, so that I can visualize data in PowerBI from Smartsheet. I have the connector working, and can pull data from Smartsheet, but it pulls the basic data (row level) for all rows with no way of distinguishing a child row to a parent row. So where I have roll-up…