Learn how Special Olympics builds their community.
Read more

Featured Communities

    Forum Stats

  • 60,011 Members
  • 38,292 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.
View All 

Discussion List

  • Announcement

    Yay! Text formatting in Smartsheet forms
    In Using Smartsheet
    Smartsheet forms now have the ability to format text in the form title, form description, and field help text. Check it out and let us know what you think. Style (Bold, Italic, Underline) Text color & highlight color Bullets & num…
    61 4
    Announcement 61 views 4 comments Most recent by Jay R Using Smartsheet
  • Insert image to cell in batch
    In Using Smartsheet
    Before I write some code, I am checking if this functionality exists. I have 400 images that will be uploaded to a Smartsheet in a batch mode. These are to be inserted into a cell in a column, not uploaded/attached to rows or the sheet. I …
    8 0
    Question 8 views 0 comments Started by J. Craig Williams Using Smartsheet
  • Hi All
    In Formulas and Functions
    I am trying to do a COUNTIFS formula in the summary field. II can get it to work with COUNTIF, however COUNTIFS returns an error (Unparseable). I am trying to get a count from two columns in the sheet to calculate in a summary field Colum…
    Answered - Pending Review
    14 3
    Answered - Pending Review 14 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • COUNTIFS across multiple columns
    In Formulas and Functions
    Hello! I'm trying to write a formula that tells me how many rows meet the criteria in multiple columns. It works with criteria in two columns, but when I try to incorporate a third, I get an incorrect argument set, or an invalid operatio…
    29 7
    Accepted Answer 29 views 7 comments Most recent by ALMF Formulas and Functions
  • Copy & paste shortcut vs. keyboard
    In Using Smartsheet
    Has anyone else experienced this, and is there a reason why this happens? When I am trying to copy and paste, it works fine when I use ctrl+c and ctrl+v, but if I try to copy using the right click option, it appears nothing happens becaus…
    7 0
    Question 7 views 0 comments Started by ejrbean Using Smartsheet
  • How do you automate a status updates in smartsheet with IF formula?
    In Formulas and Functions
    My organization would like to automate the statuses in a project plan. Could we create an IF formula to accommodate this logic? Examples: If the start date is in the past and the percentage is 0%, put status in yellow If the percentage is …
    Answered - Pending Review
    9 1
    Answered - Pending Review 9 views 1 comment Most recent by Jeff M. Formulas and Functions
  • Automatically creating event recurrences
    In Using Smartsheet
    Hi All - I am creating an event calendar (to be coupled with the Calendar App) and I would like to enable folks to submit a recurring event, noting the frequency as once a week, every 3rd Thursday, etc. I capture the initial start date, b…
    10 0
    Question 10 views 0 comments Started by Tal Margalith Using Smartsheet
  • Work Breakdown Structure (WBS) - Column Formula Configuration
    In Best Practice
    Hello Everyone, Recently myself and two fellow Smartsheet Sales Engineers, @Lea Gikas and @Dave Stanley got together to create a WBS solution powered by Column Formulas. We wanted to provide the resulting configuration to the community in…
    1193 12
    1.2K views 12 comments Most recent by Tom Zylstra Best Practice
  • Date auto fill not working?
    In Formulas and Functions
    I am trying to fill 3 months of consecutive dates without manually typing them all in, but all I get is the same 2 dates repeated, instead of consecutive dates? I am typing in the first 2 dates, then dragging the corner down, but all it do…
    10 0
    Question 10 views 0 comments Started by Angela_74 Formulas and Functions
  • The need for Forms to update an existing row and not send a request
    In Using Smartsheet
    I see the constant request to have Forms update an existing row and yet it hasn't come to fruition yet? I'm facing the same issue with the need to have users, in this case mechanics, update a Form to reflect anything they may have worked o…
    9 0
    Question 9 views 0 comments Started by VinceA Using Smartsheet
  • IF with MAX(COLLECT issue
    In Formulas and Functions
    Hello! I am stumped by a problem I'm working on. Part of my work is to assemble a dashboard that shows the maximum number of occupied beds at several homeless shelters in a given period of time during the previous night. Supervisors at eac…
    11 0
    Question 11 views 0 comments Started by Van Keuren, Jeremy Formulas and Functions
View All