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

  • Announcement

    The new Smartsheet experience
    In Using Smartsheet
    Hello Smartsheet Community! Today we are excited to announce the launch of the new Smartsheet experience. This new experience includes updates that impact the platform, including: a refreshed, modern design for most of the desktop applicat…
    1209 33
    Announcement 1.2K views 33 comments Most recent by Ashley Ryder Using Smartsheet
  • Announcement

    Free webinar: Capture E-signatures with Document Builder (April 22nd)
    In Using Smartsheet
    Join us on April 22nd to learn about the redesigned document builder, now including a direct integration with DocuSign. We'll share how to quickly create custom documents with your row data, send them for e-signature, and track the signing…
    63 0
    Announcement 63 views 0 comments Started by Anna Mkrtchyan Using Smartsheet
  • Automatically have End Date initially match Start Date
    In Formulas and Functions
    Is there a way for an End Date to always automatically match to the Start Date, but for me to have the flexibility to then select a different date if needed?
    Unanswered
    2 0
    Question 2 views 0 comments Started by Callie Langford Formulas and Functions
  • Traffic light formula problem with two conditions
    In Formulas and Functions
    Dear I have a column of% Complete (% Complete) and a Task Completion (ENDDATE) I would like to generate the following conditions: 1. Green if 100% of the task is complete and it has been given on the estimated date (which is equal to or l…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Bassam.M Khalil Formulas and Functions
  • Report Grouping Blank
    In Using Smartsheet
    Hi all - When I set the Grouping to be based on the Regional Practice column...it groups, but does not "Label" the groups with the Regional Practice name... I summarized a column to show that the data is there, grouped, but not …
    Accepted
    13 3
    Accepted Answer 13 views 3 comments Most recent by Bassam.M Khalil Using Smartsheet
  • How to autofill the status
    In Formulas and Functions
    Hello, I need to setup a formula to have the status auto updated/filled whenever the date is entered on "EUDC Date in" column. at the moment "Status" is a drop down menu and we are manually selecting the status. Than…
    Accepted
    16 9
    Accepted Answer 16 views 9 comments Most recent by Bassam.M Khalil Formulas and Functions
  • Project dashboard milestone report
    In Using Smartsheet
    Has anyone figured out how to surface a milestone report to a project dashboard and only have one date column; due date? Milestone are due on a certain date (start and end same date), they are not between two dates so all I want is the tas…
    Unanswered
    7 0
    Question 7 views 0 comments Started by Phil Wightman Using Smartsheet
  • Number of duplicates
    In Formulas and Functions
    Hello,  I'm brand new to Smartsheets. Is there a way to find the number of duplicates in a column for a specific value? For example, how many "John Smiths" are in a list of names?  Many thanks, Pltrmgrl 
    534 11
    534 views 11 comments Most recent by Julius Benn Sabeniano Formulas and Functions
  • Gantt View Weekends
    In Using Smartsheet
    Is there any way when using a gantt chart to get the task bars not to show running through weekends. This is not a major problem but we have had several of our customers who are more used to using MS Project asking us to show our charts in…
    Unanswered
    7 0
    Question 7 views 0 comments Started by CRL Planning Using Smartsheet
  • How to get minutes using this formula? The output only display 14 instead of 14:30
    In Formulas and Functions
    =VALUE(MID([12 Hour Format]@row, FIND(" ", [12 Hour Format]@row) + 1, FIND(":", [12 Hour Format]@row) - (FIND(" ", [12 Hour Format]@row) + 1))) + IF(FIND("P", [12 Hour Format]@row) > 0, 12) + 6
    Answered - Pending Review
    13 2
    Answered - Pending Review 13 views 2 comments Most recent by Alia AhmadKamal Formulas and Functions
  • Dependencies and fixed dates
    In Using Smartsheet
    Hello I've noticed several post on the archive asking for the same problem to be fixed, here are just 3 examples that go back to 2015. In my personal case, I would like to demonstrate customers: how the dependency was supposed to look li…
    Answered - Pending Review
    216 17
    Answered - Pending Review 216 views 17 comments Most recent by Emma Harris Using Smartsheet
  • Formulas for Calculating Time
    In Formulas and Functions
    I have decided to create a post that consolidates all of the different time based solutions that I have put together. Some of these solutions can be made more efficient or condensed into fewer but larger formulas. I am still going through …
    4158 59
    4.2K views 59 comments Most recent by Michelle B Formulas and Functions