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
-
First post 06/30/17,Last post 02/15/19Hello, 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…Archived 2017 Posts513jrichardw -
First post 06/30/17,Last post 07/05/17I 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 …Archived 2017 Posts26[email protected]
-
Closed Guy Rousseau 124 views 2 comments 0 points Most recent by J. Craig Williams Archived 2017 PostsFirst post 06/30/17,Last post 07/04/17I 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...Archived 2017 Posts1242Guy Rousseau
-
First post 06/30/17,Last post 07/05/17I'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. …Archived 2017 Posts292bbaker
-
First post 06/30/17,Last post 06/30/17I 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…Archived 2017 Posts1233RDM
-
Closed [email protected] 1 view 4 comments 0 points Most recent by J. Craig Williams Archived 2017 PostsFirst post 06/29/17,Last post 07/04/17I 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 …Archived 2017 Posts14[email protected]
-
First post 06/29/17,Last post 09/14/17The 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…Archived 2017 Posts122IsaacMartinez
-
First post 06/29/17,Last post 07/05/17Hi, 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 …Archived 2017 Posts11Alexis Scala
-
First post 06/29/17,Last post 07/04/17I 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…Archived 2017 Posts9355Jon Brown
-
First post 06/29/17,Last post 07/05/17I 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",=…Archived 2017 Posts977Shesha_K -
Closed Patrick Galvin 36 views 2 comments 0 points Most recent by J. Craig Williams Archived 2017 PostsFirst post 06/29/17,Last post 07/25/17I have a master sheet that has tasks for all types of projects and depending on the customer we sign, I will go through and delete the rows I no longer need. The issue is that my RYG (error: #BLOCKED) and Predecessors (error: #REF) error w…Archived 2017 Posts362Patrick Galvin
-
First post 06/29/17,Last post 06/29/17Good morning, I'm setting up an automated weekly send for a report. I need send it in the vertical format, as though you are sending a row. As it is, it sends in a PDF which is a linear format, and not user friendly for our purposes. Is …Archived 2017 Posts111Loann McGee -
First post 06/29/17,Last post 06/29/17I have a 2000 line schedule and this morning a lot of the parent rows are no longer showing the summary dates of their children. Which ones seems to be random. For columns in which I do math on the parent row that is missing summary data I…Archived 2017 Posts271Bill Brandt
-
Closed Yovanka Barnard 32 views 1 comment 0 points Most recent by Shaine Greenwood Archived 2017 PostsFirst post 06/29/17,Last post 06/30/17Hi All, I would appreciate it if someone can help me out. I double checked that my links are linking to the correct areas between two sheets. But it is not updating the sheet it links to. Please advise and see screenshot. Thanks, Y …Archived 2017 Posts321Yovanka Barnard -
First post 06/29/17,Last post 06/30/17Hi all We're working on a dashboard for senior stakeholders. At the moment we have a report that is an amalgamation of several sheets (listing risks & issues). We now want to limit that amalgamated report to only show top x rows, base…Archived 2017 Posts111dharmesh
-
First post 06/29/17,Last post 06/29/17Hi, I'm having a little trouble creating a formula for a date column. I have a 'Project type' column and a 'Project start date' column which need to determine what the 'Handover to support date' column is. Basically - for all projects th…Archived 2017 Posts132sambaxter
-
First post 06/29/17,Last post 04/30/19Hi there, I understand that you can link cells in Smartsheet between sheets, but I have been unable to link cells within a sheet - does anyone know if this is possible in any way? Thanks, PaulArchived 2017 Posts3588Paul R
-
First post 06/28/17,Last post 06/28/17I have a formula that says it is an incorrect argument. When I break up the two arguments they each work, but they are not working together. The error message is incorrect argument. I don't know why they work alone, but will not work tog…Archived 2017 Posts114Brett Wallace
-
First post 06/28/17,Last post 06/30/17Hi I would like to connect smart sheet to netsuite. Currently i am doung it through web query in excel. Does any body know how to get data into smartsheets using standard web query file? thanksArchived 2017 Posts831Mehrshad
-
Closed Brett Wallace 25 views 4 comments 0 points Most recent by Richard Rymill SBP Archived 2017 PostsFirst post 06/28/17,Last post 06/29/17I have the data connector up and running. I am able to have it take info from Smartsheets and put it into excel. This is awesome because one I press refresh it updates everything in that excel file. The only question I have is, is there an…Archived 2017 Posts254Brett Wallace
-
Closed Lucas Knepper 13 views 3 comments 0 points Most recent by J. Craig Williams Archived 2017 PostsFirst post 06/28/17,Last post 07/25/17I am trying to create a formula that can generate a date 2 weeks prior to a set date. For example: 9/1/17 - 14 days = 8/18/17 I assumed the formula would be as simple as "=[cell w/ given date] - 14" but it will not work and th…Archived 2017 Posts133Lucas Knepper
-
Closed [email protected] 36 views 9 comments 0 points Most recent by Kara Lumley Archived 2017 PostsFirst post 06/28/17,Last post 06/29/17I am having problems with creating new URLs to auto-populate web forms. All of my old ones still work, and the regular web form functions still work, but I get an error stating the form is no longer active when I try to add information to …Archived 2017 Posts369[email protected]
-
First post 06/28/17,Last post 06/29/17Hi everyone, I have question that I have two different projects can I link them? Can I able to set Predecessor from one project to other? Thanks, PranavArchived 2017 Posts151Pranav
-
Closed DaveJohnson 103 views 5 comments 0 points Most recent by [email protected] Archived 2017 PostsFirst post 06/28/17,Last post 08/19/19I recently started using the Resource Management tool and I have two questions about it. We are using 1 sheet only. 1) Is there a way to display hours vs. percent allocation? Everything I have seen with this feature thus far seems base…Archived 2017 Posts1035DaveJohnson
-
First post 06/28/17,Last post 06/28/17Has there been any further discussion on implementing this? If I create the hierarchy in a sheet, when i switch to card view, it is not giving me the view of all the "cards" that report to each parent; rather it is sorting by s…Archived 2017 Posts281MonikkaM
-
First post 06/28/17,Last post 06/29/17Background We create and approve purchase orders via Smartsheet. On receipt of the invoice to the accounts team the named approver (Contact List column) for the PO is sent an update request with the attached invoice and the field "in…Archived 2017 Posts891James Johnson-Miller
-
First post 06/28/17,Last post 11/19/19Hi, It would be very useful to have a shortcut to Collapse / Expand grouped lines, instead of clicking on the little +/- buttons. When using a lot of grouped lines it becomes really tedious to always look for these tiny buttons. Is such…Archived 2017 Posts61613Xavier LN
-
First post 06/27/17,Last post 06/28/17I'd like to try and figure out how to most effectively and efficiently connect 2 separate smartsheets together, preferably through some sort of smart formula/code. I don't think doing a manual "cell linking" from a cell in one sh…Archived 2017 Posts1492Dereck H
-
First post 06/27/17,Last post 06/29/17Using the formula below in combination with predecessors (FS -5d) I get an intermittent #blocked error. Sometimes when I make a change (add a date / change predecessor) it goes away. I can make a change, undo the change, and the error is g…Archived 2017 Posts501Preston -
First post 06/27/17,Last post 06/27/17Is there a way to have alerts be sent out automatically notifying the next team member that a dependency they were waiting on is now done based on tasks being marked as complete?Archived 2017 Posts461tylermh