-
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!
-
Smartsheet needs to have differentiation between a "text" column type and a number
When integrating data in other apps and programs, the data type is critical. Additionally, We need to be able to lock out the data type in the entry. I should not be allowed to type text into a date field or text into a number field. etc. This will enhance the reporting and BI usefulness of this tool.
-
Smart Sheet Expert User
Seeking a smart sheet expert user able to to offer consultancy services. Wishing to use the software as a database to read and report on a number of sheets.
-
c# Smartsheet API: Can Not Get ColumnId
I am trying to read data from Smartsheet using C# SDK. I can get sheet info but column details such as ColumnId are Null. When I run the code below, I can get sheet and its columns. Bu only column name and type are filled, other properties of columns are Null. What am I doing wrong? using System; using…
