-
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…
-
CELL LINKING
I AM USING SMARTSHEET TO HANDLE MY BUSINESS, ie: TRAVEL AGENCY. I WANT A WAY BY WHICH ALL MY DRIVERS CAN UPLOAD ABOUT THEIR AVAILABILITY AND THEN ALL THESE THINGS COME DIRECTLY TO MY SHEET. AND THE DRIVERS SHOULDNT BE ALLOWED TO VIEW MY SHEET, FOR THAT I THOUGHT OF CREATING A SEPERATE SHEET FOR EACH AND EVERY DRIVER AND…
-
Export sheet URLs to excel
Hi, I'm trying to export multiple secure sheet links (urls) to excel (or pull them into a report) so I can upload them to a field in Salesforce. Is there any easy way to do this? Thanks for your help!
