Join the Smartsheet Community

Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.

Discussion List

  • Report not filtering out all 100% complete tasks
    In Using Smartsheet
    I have a report to show me all of the tasks that are in progress (not 100% complete) or not started within a timeframe. Therefore, the report is supposed to filter OUT all tasks that at 100% complete. It has been working for over two year…
    54 views 4 comments Most recent by JeremiahHorstick Using Smartsheet
  • Last Week's Value
    In Formulas and Functions
    Hi All, Does anyone know of a formula that can pull the values from an existing column from the week prior using the cell history or activity log? e.g. I can see the value last week in the cell history but I want to pull it automatically…
    Answered - Pending Review
    14 2
    Answered - Pending Review 14 views 2 comments Most recent by JeremiahHorstick Formulas and Functions
  • Email to Smartsheet to create new row in Sheet
    In Using Smartsheet
    I'd love to have a discreet email address tied to a sheet so that I could forward it emails as a way to create new tasks. I can't get force people to use a form so it would sure be handy to just set a rule that forwards to an email address…
    Answered - Pending Review
    14 1
    Answered - Pending Review 14 views 1 comment Most recent by JeremiahHorstick Using Smartsheet
  • What's wrong with my formula?
    In Formulas and Functions
    =COUNTIFS(Position2:Position196, CONTAINS("Medical Assistant", @cell), [Cleared to Return?]2:[Cleared to Return?]136, OR(CONTAINS("No", @cell), CONTAINS("Contingent", @cell)))
    Answered - Pending Review
    20 2
    Answered - Pending Review 20 views 2 comments Most recent by Mike Wilday Formulas and Functions
  • How to send an alert when a ticket is reassigned.
    In Using Smartsheet
    I need the system to send out an alert when the 'Assigned To' contact list field changes to a value other than the current value. I have an Alert automation configured with a Trigger: When rows are changed. And When 'Assigned To' changes …
    Answered - Pending Review
    13 1
    Answered - Pending Review 13 views 1 comment Most recent by Mark Cronk Using Smartsheet
  • Count by event identifier
    In Formulas and Functions
    Hey ho, Looking to set up a counter of survey findings for different surveys (i.e. Oct 2018, July 2019, Dec 2020 may all have a count) recorded on one sheet so a dashboard widget will display that number. Ideally the widget can have a sel…
    Unanswered
    24 0
    Question 24 views 0 comments Started by Guy Paterson Formulas and Functions
  • Enter date based on check box
    In Using Smartsheet
    I have a "closed" check box in my sheet.  Based on that being checked, I want to automatically fill a closed date in another column.  Not sure how to do that.  Help!  Thanks  
    473 10
    473 views 10 comments Most recent by Robert Cozby Using Smartsheet
  • Using Month/Year in formula
    In Formulas and Functions
    Am I missing an easy way to pull in a count based off month in a chart? For ex. My chart shows July and I would like my formula to count events based off the July name in the chart (@row), I could only figure this out using a month helper …
    Answered - Pending Review
    22 3
    Answered - Pending Review 22 views 3 comments Most recent by Mark Cronk Formulas and Functions
  • How do I copy and paste hyperlinks from Excel?
    In Using Smartsheet
    I have a spreadsheet of bug numbers linked to the bug database. Why can’t I copy and paste from excel to smartsheet retaining the hyperlinks? Seems like a feature smartsheet would have!
    Answered - Pending Review
    303 4
    Answered - Pending Review 303 views 4 comments Most recent by Andrew Detolla Using Smartsheet