Archived 2017 Posts

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

  • jrichardw
    Closed jrichardw 51 views 3 comments Most recent by Erik Beltran Archived 2017 Posts
    First post 06/30/17,Last post 02/15/19
    Hello, 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 Posts513
    jrichardw
  • L@123
    Closed [email protected] 2 views 6 comments Most recent by Mike Wilday Archived 2017 Posts
    First post 06/30/17,Last post 07/05/17
    I 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]
  • Guy Rousseau
    Closed Guy Rousseau 124 views 2 comments Most recent by J. Craig Williams Archived 2017 Posts
    First post 06/30/17,Last post 07/04/17
    I 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 Posts1242
    Guy Rousseau
  • bbaker
    Closed bbaker 29 views 2 comments Most recent by bbaker Archived 2017 Posts
    First post 06/30/17,Last post 07/05/17
    I'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 Posts292
    bbaker
  • RDM
    Closed RDM 123 views 3 comments Most recent by Mike Wilday Archived 2017 Posts
    First post 06/30/17,Last post 06/30/17
    I 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 Posts1233
    RDM
  • L@123
    Closed [email protected] 1 view 4 comments Most recent by J. Craig Williams Archived 2017 Posts
    First post 06/29/17,Last post 07/04/17
    I 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]
  • IsaacMartinez
    Closed IsaacMartinez 12 views 2 comments Most recent by Brad Jones Archived 2017 Posts
    First post 06/29/17,Last post 09/14/17
    The 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 Posts122
    IsaacMartinez
  • Alexis Scala
    Closed Alexis Scala 1 view 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
    First post 06/29/17,Last post 07/05/17
    Hi,   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 Posts11
    Alexis Scala
  • Jon Brown
    Closed Jon Brown 935 views 5 comments Most recent by J. Craig Williams Archived 2017 Posts
    First post 06/29/17,Last post 07/04/17
    I 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 Posts9355
    Jon Brown
  • Shesha_K
    Closed Shesha_K 97 views 7 comments Most recent by Mike Wilday Archived 2017 Posts
    First post 06/29/17,Last post 07/05/17
    I 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 Posts977
    Shesha_K
  • Patrick Galvin
    First post 06/29/17,Last post 07/25/17
    I 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 Posts362
    Patrick Galvin
  • Loann McGee
    Closed Loann McGee 11 views 1 comment Most recent by Loann McGee Archived 2017 Posts
    First post 06/29/17,Last post 06/29/17
    Good 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 Posts111
    Loann McGee
  • Bill Brandt
    Closed Bill Brandt 27 views 1 comment Most recent by Mike Wilday Archived 2017 Posts
    First post 06/29/17,Last post 06/29/17
    I 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 Posts271
    Bill Brandt
  • Yovanka Barnard
    Closed Yovanka Barnard 32 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
    First post 06/29/17,Last post 06/30/17
    Hi 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 Posts321
    Yovanka Barnard
  • dharmesh
    Closed dharmesh 11 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
    First post 06/29/17,Last post 06/30/17
    Hi 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 Posts111
    dharmesh
  • sambaxter
    Closed sambaxter 13 views 2 comments Most recent by sambaxter Archived 2017 Posts
    First post 06/29/17,Last post 06/29/17
    Hi, 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 Posts132
    sambaxter
  • Paul R
    Closed Paul R 358 views 8 comments Most recent by Jecathcart Archived 2017 Posts
    First post 06/29/17,Last post 04/30/19
    Hi 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, Paul
    Archived 2017 Posts3588
    Paul R
  • Brett Wallace
    Closed Brett Wallace 11 views 4 comments Most recent by Mike Wilday Archived 2017 Posts
    First post 06/28/17,Last post 06/28/17
    I 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 Posts114
    Brett Wallace
  • Mehrshad
    Closed Mehrshad 83 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
    First post 06/28/17,Last post 06/30/17
    Hi 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? thanks
    Archived 2017 Posts831
    Mehrshad
  • Brett Wallace
    Closed Brett Wallace 25 views 4 comments Most recent by Richard Rymill SBP Archived 2017 Posts
    First post 06/28/17,Last post 06/29/17
    I 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 Posts254
    Brett Wallace
  • Lucas Knepper
    Closed Lucas Knepper 13 views 3 comments Most recent by J. Craig Williams Archived 2017 Posts
    First post 06/28/17,Last post 07/25/17
    I 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 Posts133
    Lucas Knepper
  • L@123
    Closed [email protected] 36 views 9 comments Most recent by Kara Lumley Archived 2017 Posts
    First post 06/28/17,Last post 06/29/17
    I 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]
  • Pranav
    Closed Pranav 15 views 1 comment Most recent by Richard Rymill SBP Archived 2017 Posts
    First post 06/28/17,Last post 06/29/17
    Hi 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, Pranav
    Archived 2017 Posts151
    Pranav
  • DaveJohnson
    Closed DaveJohnson 103 views 5 comments Most recent by [email protected] Archived 2017 Posts
    First post 06/28/17,Last post 08/19/19
    I 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 Posts1035
    DaveJohnson
  • MonikkaM
    Closed MonikkaM 28 views 1 comment Most recent by Mike Wilday Archived 2017 Posts
    First post 06/28/17,Last post 06/28/17
    Has 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 Posts281
    MonikkaM
  • James Johnson-Miller
    Closed James Johnson-Miller 89 views 1 comment Most recent by ricki Archived 2017 Posts
    First post 06/28/17,Last post 06/29/17
    Background 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 Posts891
    James Johnson-Miller
  • Xavier LN
    Closed Xavier LN 616 views 13 comments Most recent by JBudd Archived 2017 Posts
    First post 06/28/17,Last post 11/19/19
    Hi, 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 Posts61613
    Xavier LN
  • Dereck H
    First post 06/27/17,Last post 06/28/17
    I'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 Posts1492
    Dereck H
  • Preston
    Closed Preston 50 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
    First post 06/27/17,Last post 06/29/17
    Using 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 Posts501
    Preston
  • tylermh
    First post 06/27/17,Last post 06/27/17
    Is 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 Posts461
    tylermh