Webinar: How to become a Smartsheet Mobilizer
Learn from Sarasota County Government on how they built an internal Smartsheet community to share knowledge and inspire.

Register now

Featured Communities

    Forum Stats

  • 54,577 Members
  • 33,121 Discussions
  • 126,130 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.
View All 

Discussion List

  • Announcement

    New! Clear cell automated action + change cell enhancement
    In Product Announcements
    Hi Community, I’m the product manager for automated workflows at Smartsheet and am pleased to share two announcements with you. First, you can now use a workflow to automatically delete the contents of a cell whenever the conditions you’ve…
    60 1
    Announcement 60 views 1 comment Most recent by SK Product Announcements
  • Announcement

    What would you like to see us doing more of in the Community?
    In General Announcements
    What can we do to help make the Community more valuable for you? We want to hear from YOU! Of the following options which would you most like to see us doing more of? If you have other suggestions you would like to share, please feel free…
    102 4
    Poll Announcement 102 views 4 comments Most recent by James Allen General Announcements
  • Join Collect Distinct
    In Formulas and Functions
    Smartsheet Community: Not Sure what I am doing Wrong but I am trying to Collect Data in another Sheet only Once. Therefore if it appears twice in that Sheet in that Colum, it should only Collect it Once. Current Formula: =JOIN(DISTINCT(COL…
    Accepted
    12 3
    Accepted Answer 12 views 3 comments Most recent by Ray B Formulas and Functions
  • Is there a limit to adding VLOOKUPs?
    In Formulas and Functions
    I am working to sum multiple columns that match a specific criteria. I was able to accomplish this with the SUM formula and using VLOOKUP. It works when I add 2 VLOOKUP formulas together but if I add more, it says #NO MATCH. Is there a lim…
    Answered - Pending Review
    9 2
    Answered - Pending Review 9 views 2 comments Most recent by Kelly Pratt Formulas and Functions
  • Can this formula be fixed to get the correct time?
    In Formulas and Functions
    Hello, I am trying to come up with a formula to track time in Smartsheet. This is the formula I have: =IF([End Time]@row < [Start Time]@row, ((1200 + [End Time]@row) - [Start Time]@row) * 0.01, (([End Time]@row - [Start Time]@row) * 0.0…
    Unanswered
    2 0
    Question 2 views 0 comments Started by Larissa Motts Formulas and Functions
  • IF is Integer?
    In Formulas and Functions
    I have a formula column that is constantly changing and bringing in live information. If the numbers are integers, I want to see them rounded with no decimal point. If the numbers do have decimals, I want to see only 1 decimal place. Press…
    Accepted
    9 5
    Accepted Answer 9 views 5 comments Most recent by Bassam Khalil Formulas and Functions
  • Grouping dates in reports not working as expected
    In Formulas and Functions
    We have started using the grouping function within several reports and grouping on a date field but we are coming across tasks with the same dates not appearing within the same grouping? We are not grouping by any other column and the for…
    Answered - Pending Review
    73 15
    Answered - Pending Review 73 views 15 comments Most recent by Vicky Athersmith Formulas and Functions
  • Can I change the order of my secondary grouping in the Calendar App?
    In Apps, Integrations, and Add Ons
    Hi, I'm having an issue getting the order of my groupings for my secondary column to appear on the Calendar App in the proper order. I am using a multi-select column from my main sheet. I understand I can not dissect the individual select…
    Unanswered
    4 0
    Question 4 views 0 comments Started by Adam Belohradsky Apps, Integrations, and Add Ons
  • Date Visibility Logic Check
    In Formulas and Functions
    I have 3 dates (Calc, Planned and Actual). I want a logical function to check and pick the most accurate during the project lifecycle. It starts with a Calculated date and then Planned is updated as the proposals come in. As the vendor …
    Unanswered
    9 0
    Question 9 views 0 comments Started by Keith Wertman Formulas and Functions
  • Checkmark Column Formula
    In Formulas and Functions
    Afternoon, I have tried every formula in the book to count all check marked boxes within a column. Can anyone just write the formula that works for them? This is the formula I am trying to make work- =COUNTIFS([Construction Complete- No…
    Answered - Pending Review
    11 6
    Answered - Pending Review 11 views 6 comments Most recent by Andrée Starå Formulas and Functions
  • Formula for Lights
    In Formulas and Functions
    Hi all, I have a sheet that contains fields for "Preparer Due Date" and "Preparer Status" and am trying to add in the following logic to a formula: Blue = completed Green = task not started or in process that are due …
    Unanswered
    5 0
    Question 5 views 0 comments Started by Brennan Montoni Formulas and Functions
  • Converting from Trial to License user
    In Using Smartsheet
    Best practice in adding new person onto Smartsheets. We have an open license, but the new user is currently using the free trial.  How do prevent any loss in data & ensure easy transition?
    Unanswered
    3 0
    Question 3 views 0 comments Started by Bob Shap Using Smartsheet
View All