Discussion List

  • Reporting: Linking two sheets on a common column
    In Archived 2016 Posts
    In reporting I have picked two sheets. They have a common primary column name. The columns do consolidate (i.e. there is only one column with this name). But...I have two rows for each, i.e. row 1 is from sheet 1 and row 2 is from sheet tw…
    33 1
    Closed 33 views 1 comment Most recent by J. Craig Williams Archived 2016 Posts
  • Anyone else's sheets not filtering since May 7th release
    In Archived 2016 Posts
    Our reports are no longer filtering on key fields like status and priorities.  We noticed it on Monday May 9th and everything was working fine May 6th.  Makes our reports contain alot of past items as now not filtering out complete tasks.…
    1 3
    Closed 1 view 3 comments Most recent by Gary Maddren Archived 2016 Posts
  • smart change of column name
    In Archived 2016 Posts
    Hi,   i need to change several column names in my smartsheet. I have entire workspace built around this sheet, using it as data source. I have multiple reports that show/filter on this column, and if i simply change the name, reports st…
    183 3
    Closed 183 views 3 comments Most recent by J. Craig Williams Archived 2016 Posts
  • time based reports?
    In Archived 2016 Posts
    I'm sure what I'm looking to do is not that difficult, I just can't find a way to achieve it. What I have is a sheet that consists of quote amounts ($) that are relative to a quote date. What I want to do is to look at how many dollars we …
    85 1
    Closed 85 views 1 comment Most recent by Brandon Tarver Archived 2016 Posts
  • Enhancement Request: Open new Report for editing
    In Archived 2016 Posts
    is there a reason that when I create a new Report (using the Create New button/menu) that the Report does not immediately open for editing?   (I can't think of one)   Craig
    13 2
    Closed 13 views 2 comments Most recent by J. Craig Williams Archived 2016 Posts
  • users feel intimidated by Smartsheet
    In Archived 2016 Posts
    I collaborate with many people who have no PM experience and/or prefer memo-style information over cell-based.  Some people feel overwhelmed by the tool so they send emails rather than update Smartsheet.  Beyond the training and show-me se…
    1 12
    Closed 1 view 12 comments Most recent by YouReachedEd Archived 2016 Posts
  • Using Smartsheet data to populate project documents
    In Archived 2016 Posts
    I looking for opportunities to streamline the production of project updates / documentation by trying work out the best way to use data already captured in various smartsheets to populate project updates to our product development steering…
    86 3
    Closed 86 views 3 comments Most recent by Richard Rymill SBP Archived 2016 Posts
  • Reports / Master Calendar
    In Archived 2016 Posts
    Hi there, it's me again. So here's the thing... We are a small test facility. We are trying to track jobs that are nothing like eachother using the same equipment and people resources. Sometimes we have 2 people resources on the same job…
    51 2
    Closed 51 views 2 comments Most recent by Heidi Decker Archived 2016 Posts
  • Display report data rolled Up?
    In Archived 2016 Posts
    Hi there   I’m currently running an exercise where we are asking a group of 30 users 10 sets of questions each. Each set of questions has its own web form so there should be 10 responses from each user (300 separate rows in total). I hav…
    72 6
    Closed 72 views 6 comments Most recent by J. Craig Williams Archived 2016 Posts
  • Add Years to a Date
    In Archived 2016 Posts
    If Term_Effective_Date = 12/07/15 and Terms_In_Year = 3 Years.   What is the formula to calcuate the New Date? I need to add 3 years to 12/07/15.    =DATE(YEAR(Term_Effecitve_Date2) + [Terms_In _Year]2, MONTH(Term_Effecitve_Date2), DAY…
    556 2
    Closed 556 views 2 comments Most recent by Amanda Chu Archived 2016 Posts