A new Smartsheet experience is here

Check out the changes

Learn more

Featured Communities

    Forum Stats

  • 52,103 Members
  • 30,818 Discussions

Recent Discussions

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

    Introducing baselines for project management, available now!
    In Using Smartsheet
    Hi Community,  We are excited to announce the launch of baselines - a fixed reference point in time to measure and compare a project’s progress to completion. Capturing and comparing variances between the current actual schedule and the or…
    228 5
    Announcement 228 views 5 comments Most recent by SK Using Smartsheet
  • Announcement

    Register now for ENGAGE 2021 Special Edition!
    In Announcements
    Join us online on Tuesday, June 8th from 9-10:30 a.m. PDT for a special virtual edition of ENGAGE! You’re invited to ENGAGE ALL IN, a special virtual edition of our customer conference, where we’ll help business leaders like you unleash t…
    50 3
    Announcement 50 views 3 comments Most recent by MCorbin Announcements
  • Determine proof dates based on asset lead times
    In Formulas and Functions
    I want to determine a 1st proof due date based on asset type and days to complete. I have another Smartsheet listing all asset types and # of days. I have various columns that list asset choices. when any of these columns have an asset typ…
    Answered - Pending Review
    6 3
    Answered - Pending Review 6 views 3 comments Most recent by Pam Dunn Formulas and Functions
  • How do I automatically capture the date a dashboard was last updated?
    In Using Smartsheet
    Hey there, Is there a way to automatically record the most recent date a dashboard was changed? There are several widgets that are present, such as Reports, Rich Text, etc. I have highlighted the area where I'd like to indicate this change…
    2 0
    Question 2 views 0 comments Started by Mohamed Ali Using Smartsheet
  • Formula/Summary Function
    In Formulas and Functions
    I want to be able to summarize how much our locations are requesting in funds, can someone help me with a formula? Column A - Month Column B - Date of Request Column C - Amount Column D - Agency (single select dropdown) Column E - Use of f…
    3 0
    Question 3 views 0 comments Started by Carrie Clark Formulas and Functions
  • How can get the most recently register of FSE from table 1 and send the name of FSE to table 2
    In Formulas and Functions
    Mi situation is that need review int the table 1 who have the 280.1 and once i identify the most recently register need send the name of the FSE who has the 280.1 to table 2 Table 1 Table 2 This I need
    11 5
    Accepted Answer 11 views 5 comments Most recent by Jonathan Salinas Formulas and Functions
  • Auto send a completed form to an email address
    In Using Smartsheet
    Hi, I am fairly new to Smartsheet, and was able to create a sheet and a linked form to replace our old HR blast process. My question is this, I created a form, and we have a list of users who needs to get an update/notified of all fields…
    1275 16
    Accepted Answer 1.3K views 16 comments Most recent by Joe Araujo Using Smartsheet
  • Formula Help Countifs and Match
    In Formulas and Functions
    I'm trying to develop a cross sheet formula that will give me an error message if I've over-allocated equipment. This is What I've come up with so far but I get Incorrect argument. =IF(COUNTIFS(MATCH([Equipment Required]@row, {Equipment T…
    3 0
    Question 3 views 0 comments Started by Matthew Emrich Formulas and Functions
  • Timed Approval Process
    In Using Smartsheet
    I am trying to set up an Approval workflow where if the first approver didn't respond within the first 48 hours, the form needs to go to the second approver. Is there a way to do that?
    Answered - Pending Review
    29 9
    Answered - Pending Review 29 views 9 comments Most recent by Rabi Baig Using Smartsheet
  • Make my primary column a contact list
    In Using Smartsheet
    Hi, I would like to make my primary column a contact list. I know that this is not possible so I tried to copy the whole column using a simple = formula, but as Smartsheet only has 50 cells, this is only a temporary solution. My goal is to…
    Answered - Pending Review
    11 2
    Answered - Pending Review 11 views 2 comments Most recent by Fritz Schiltz Using Smartsheet
  • Adding 1 day to date in an If formula
    In Formulas and Functions
    Hello. I am trying to add one day to a date if the row meets a certain condition. Instead of adding the day, it is putting a "1" at the end of the date string. I have confirmed both the original date and the column with the for…
    Answered - Pending Review
    10 5
    Answered - Pending Review 10 views 5 comments Most recent by Leibel S Formulas and Functions