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

  • Predecessors and Formula's Error when I delete rows
    In Archived 2017 Posts
    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…
    71 2
    Closed 71 views 2 comments Most recent by J. Craig Williams Archived 2017 Posts
  • Automated send format question
    In Archived 2017 Posts
    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 …
    12 1
    Closed 12 views 1 comment Most recent by Loann McGee Archived 2017 Posts
  • sheet stopped functioning
    In Archived 2017 Posts
    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…
    32 1
    Closed 32 views 1 comment Most recent by Mike Wilday Archived 2017 Posts
  • Links not updating
    In Archived 2017 Posts
    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
    95 1
    Closed 95 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
  • Getting top x rows
    In Archived 2017 Posts
    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…
    14 1
    Closed 14 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
  • Conditional date formula
    In Archived 2017 Posts
    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…
    11 2
    Closed 11 views 2 comments Most recent by sambaxter Archived 2017 Posts
  • Cell linking within a sheet
    In Archived 2017 Posts
    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
    1284 8
    Closed 1.3K views 8 comments Most recent by Jecathcart Archived 2017 Posts
  • Formula Help
    In Archived 2017 Posts
    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…
    11 4
    Closed 11 views 4 comments Most recent by Mike Wilday Archived 2017 Posts
  • Pulling data using web query file
    In Archived 2017 Posts
    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
    129 1
    Closed 129 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
  • Live Data Connector Reverse Upload
    In Archived 2017 Posts
    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…
    22 4
    Closed 22 views 4 comments Most recent by Richard Rymill SBP Archived 2017 Posts