Meet our 2020 Overachievers!
Learn more

Featured Communities

    Forum Stats

  • 45,476 Members
  • 25,295 Discussions
  • 97,674 Comments

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

    Create the Conversation: #CanDoCommunity Event with Carlos Watson
    In The New Work/Life Reality
    #CanDoCommunity is back! In January 2021, Smartsheet is hosting a virtual #CanDo Community Q&A event with Carlos Watson, CEO & Co-Founder of the Emmy Award and Webby Award winning media company OZY Media. He will be joining us to t…
    Announcement 35 views 0 comments Started by Maxwell Griffith The New Work/Life Reality
  • Announcement

    Update Request Confirmation Email Change
    In Using Smartsheet
    Hi Community, As many of you know, Smartsheet has always sent a confirmation email anytime someone responds to an update or approval request. Based on customer feedback, we have made the confirmation optional. Each respondent can now opt i…
    Announcement 98 views 3 comments Most recent by Sam Fox Using Smartsheet
  • Column Formula for Health with check for Parent
    In Using Smartsheet
    I am using the following formula to drive the RYG ball color in a Health column. The color reflected in the Health column is driven by a combination of "Complete" (checked boxes) and "Due Date" data.  GREEN = Complete …
    Accepted
    23 4
    Accepted Answer 23 views 4 comments Most recent by KDM Using Smartsheet
  • Weekly Schedule Forecast
    In Using Smartsheet
    Currently we use Excel to create a weekly scheduled forecast for our scheduling agents to know when they are on break, lunch or in training. I am hoping to replicate that in Smartsheet. Please see the attached current tool. Is there anyw…
    Unanswered
    5 0
    Question 5 views 0 comments Started by Leni Burrow Using Smartsheet
  • Risk Heat Map
    In Formulas and Functions
    I have developed a risk register using a rating of likelihood and severity to determine 1 of 25 possible risk profiles. I want to provide a visual presentation of the overall risk profile (summary of the whole risk register). In the past I…
    Unanswered
    5 0
    Question 5 views 0 comments Started by Lakmal Kamalgoda Formulas and Functions
  • How do I link QR Codes to Smartsheet lines
    In Using Smartsheet
    The aim of the project is to attach bar codes to equipment, so when the maintenance folk scan the code it takes them to the line in Smartsheet where the equipment information and Maintenance Plan is located. They can then download & po…
    Unanswered
    4 0
    Question 4 views 0 comments Started by James Kenny Using Smartsheet
  • How can I lock a cell once it is populated?
    In Using Smartsheet
    I have assigned numbers to each of my rows and have created a column to populate the CHILDREN with the number of the PARENT so I can tie the relationship back. For instance, if I close out the CHILD, I want to be able to tell which PARENT…
    Answered - Pending Review
    8 1
    Answered - Pending Review 8 views 1 comment Most recent by Mark C. Using Smartsheet
  • Red / Yellow / Amber formula
    In Formulas and Functions
    Hi, Can anone please suggest for my sheet that is formatted as shown in the attached image and for the following conditions if risk/issues cell is not blank and due date is in the future then yellow if past due date then red if past du…
    Answered - Pending Review
    51 3
    Answered - Pending Review 51 views 3 comments Most recent by Mark C. Formulas and Functions
  • substracting empty cells gives #invalid operation
    In Formulas and Functions
    column 1 & 2: data, column 4: data column 3: =IF(SUM([email protected]:[email protected]) = 0, "", (SUM([email protected]:[email protected]))) so if column 1 plus column 2 equal 0 the cell stays blank. this part of the function works well in column…
    Accepted
    20 3
    Accepted Answer 20 views 3 comments Most recent by Mark C. Formulas and Functions
  • Pulling data only for current year
    In Formulas and Functions
    I have a metric sheet pulling in data from a pipeline report to show how many closed deals we have for that region from 2016 thru to today. I now need to add a formula to show only the closed deals within that region for 2020 and display…
    Answered - Pending Review
    7 1
    Answered - Pending Review 7 views 1 comment Most recent by Mark C. Formulas and Functions
  • % Complete Average Column Formula
    In Formulas and Functions
    I am currently using a Column Formula to calculate % Complete. The formula is a combination of two checks: Children rows calculate based on a check box "Complete" column. The % complete will be calculated as 0% for an unchecked…
    Answered - Pending Review
    10 1
    Answered - Pending Review 10 views 1 comment Most recent by Mark C. Formulas and Functions
  • Insert approvers name and date/ time of approval
    In Formulas and Functions
    Hi all, I have created a form and a workflow for approval. In short: Somone submits a form Details email to an approver Approver either approves or declines (would also be good to have more than 2 options i.e. defer) The smartsheet updates…
    Accepted
    127 5
    Accepted Answer 127 views 5 comments Most recent by Justin Reed Formulas and Functions