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

  • Auto Sort Smartsheet
    In Using Smartsheet
    I've seen a few threads about this already, but none seem to have an acceptable solution. My particular use case is this: We have a Master Schedule sheet with over 100 active projects (this sheet is updated by various project managers). E…
    Accepted
    653 4
    Accepted Answer 653 views 4 comments Most recent by Ben H Using Smartsheet
  • REPORT: Grouping problems
    In Using Smartsheet
    Since the last update of the platform the grouping feature seems not working properly in some sheets. It says as attached that means "To see lines in every group change the filter criteria to reduce lines from 72" I do not und…
    Unanswered
    7 0
    Question 7 views 0 comments Started by radix Using Smartsheet
  • COUNTIF or COUNTIFS formula for a date column, criteria based off MONTH and YEAR
    In Formulas and Functions
    I am trying to total the number of completed submissions on my Ankeny Repair spreadsheet based off of a specific month from a specific year. Range 4 is the column with the completed dates. My current formula is this... =COUNTIFS(MONTH({Ank…
    Accepted
    519 10
    Accepted Answer 519 views 10 comments Most recent by Sue Hill Formulas and Functions
  • Current Week and Next Week Formula
    In Formulas and Functions
    Hi, I need help with a formula that will help me determine if a date is the current week or the next week in the calendar. Need the weeks to star on Sundays. I'm using the following two formulas: For Current Week I'm using the following fo…
    Answered - Pending Review
    19 2
    Answered - Pending Review 19 views 2 comments Most recent by Rajul Khandelwal Formulas and Functions
  • Attachments in notes
    In Using Smartsheet
    Can attachments be attached to a note or message line in SmartSheet and when you use the @ symbol will it email the attachment as well or at least let the person know you attached something? I cant seem to add a comment and have the pers…
    Answered - Pending Review
    18 1
    Answered - Pending Review 18 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Smartsheet to Alteryx connection
    In Premium Apps and Integrations
    Hi there, Does anyone have any info of how to link up smartsheets to Alteryx, so that Alteryx is able to pull in information from Smartsheets? Thanks in advance!
    Answered - Pending Review
    10 1
    Answered - Pending Review 10 views 1 comment Most recent by Andrée Starå Premium Apps and Integrations
  • Report Message
    In Using Smartsheet
    Why do I get this message every time I access a report for the first time since logging in?? My report already exists and I have to click on Get Started and then click out of the folder selection box to continue with my report.
    Answered - Pending Review
    15 1
    Answered - Pending Review 15 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Formulas to identify duplicates
    In Formulas and Functions
    My company is assigning decals to vehicles to monitor our guests. Is there a formula to identify if a license plate has already received a decal if I am looking at my sheet? We will have 2000+ license plates and need this to be a quick gla…
    Answered - Pending Review
    16 1
    Answered - Pending Review 16 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Question on IF / AND OR Formula
    In Formulas and Functions
    Hello, I have this formula that works great. I would like to add one criteria to it, however. If a new column (not currently referenced here, which contains a "priority status" (different than "status") that is "hi…
    Answered - Pending Review
    15 1
    Answered - Pending Review 15 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • IF #INVALID OPERATION
    In Formulas and Functions
    Hi I am using this formula to define Health of the project with symbols in the summary sheet =IF([Gap vs SMS]15 >= 14, "Yes", IF(14 > [Gap vs SMS]15 >= 0, "Hold", IF([Gap vs SMS]15 < 0, "No"))) For…
    Answered - Pending Review
    13 1
    Answered - Pending Review 13 views 1 comment Most recent by Andrée Starå Formulas and Functions