Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Archived 2017 Posts
Archives for June 2017
Discussion List
-
C# API Add Records from MS SQL ServerIn Archived 2017 PostsHello, I'm trying to get records from a SQL table into Smartsheet using C# and ultimately SSIS (via script command). I'm stuck on how to add the rows into Smartsheet. 1. I want to add the rows dynamically without having to code the colum…
-
formula helpIn Archived 2017 PostsI am attempting to get a formula to count a range if the column next to it has the correct category. for example DF 1.1 DV 2.1 DF 3.3 DF 1.2 DV 2.1 I want to count how many numbers lay between 1 and 2 in the category DF, and am …
-
% Completed and Task FinishedIn Archived 2017 PostsI would like to have the % completed set automatically to 100% when the Task Finished is checked. Any suggestion on how to do that? First smartsheet struggles...
-
formulas disappearingIn Archived 2017 PostsI'm having an issue with the formula I created to automatically check a box disappearing if I happen to manually check that box. I have it set up so when a certain box is check marked this will cause another box to then be check marked. …
-
NETDAYS FormulaIn Archived 2017 PostsI cannot for the life of me figure out why the NETDAYS formula is not working for me. Let's say I have my start date as 6/30/17 in cell 6 under column 2 and that my finish date as 7/26/17 is in cell 6 under column 4. I select the appropr…
-
Implementation of web forms IdeaIn Archived 2017 PostsI have been working on a somewhat complicated 5S audit for a while and I thought I would share one of my favorite ideas we have had. We needed to create an audit sheet that was filterable by plant, then area, then by zone, and could have …
-
Smartsheet Slow Response TimeIn Archived 2017 PostsThe more rows and columns a smartsheet has, the slower its response time. It other words, I am constantly using smartsheet with thousands of rows and columns. As a result, I am constantly waiting for your servers to process and save my wor…
-
Double Entry from WebformIn Archived 2017 PostsHi, I am having an issue where we are using QR codes to access the webform on a mobile device and the data being sent through 2-3 times. There is double data and it is causing us to have to comb data and delete unnecessary entries. Is …
-
Auto populate cell informationIn Archived 2017 PostsI have built a sheet for tracking production downtime in our facility. I am looking to be able to streamline the amount of time it takes someone to entry sku specific information. So say the item has the following traits (Sku Number: 103…
-
RYGB BallsIn Archived 2017 PostsI created a nested function to color designate the status of my projects tasks: =IF(Status="Not Started","Red", =IF(Status="In Progress","Yellow",=IF(Status="Complete", "Green",=…