Formulas and Functions

Let the community help you with that tricky formula or function! See how others are utilizing the power of formulas and functions to save them time and create more powerful solutions with Smartsheet.

Discussion List

  • Count of Selections within a Multi-Select Dropdown
    In Formulas and Functions
    Hey there! I am looking for assistance in counting the values within a cell that is formatted as a multi-select dropdown for each date associated with the creation of the Smartsheet line. The creation date of the line is being populated fr…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Mark Cronk
  • How to change formula for more then one criteria
    In Formulas and Functions
    So this formula works for me. I am trying to add another criteria though and cant figure it out. =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Stained") And it works but i want it to add the "s…
    Answered - Pending Review
    13 3
    Answered - Pending Review 13 views 3 comments Most recent by Mike Wilday
  • COUNTIFS not working correctly
    In Formulas and Functions
    I wan to count the number of projects that meet these criteria: Maintenance project, not an improvement project Not canceled (so status could be "Completed", "In Progress", "Not Started", etc. Matches a term c…
    Accepted
    15 7
    Accepted Answer 15 views 7 comments Most recent by Mark Cronk
  • COUNTIFS function showing error
    In Formulas and Functions
    I am counting the nos. of specific activity within the specific month. (Two different columns) Want this formula in the summary sheet. tried several ways but didn't get the desired results. I tried =COUNTIFS([Activity Type]:[Activity Type]…
    16 views 1 comment Most recent by KDM
  • Sum a column of numbers only if they meet certain criteria.
    In Formulas and Functions
    I hope this makes sense. I am trying to add up all the numbers is column "Slides". But I only want to include the numbers if the done is not checked. I also not not want to include the number if column "Status" says Sco…
    Accepted
    21 5
    Accepted Answer 21 views 5 comments Most recent by Mark Cronk
  • Avg of a range with 2 criteria
    In Formulas and Functions
    Hi! I am trying to average a range (which are percentages) based on the Issue Date Year and the Type. I have tried: =AVG(COLLECT({Row Averages}, {QA Type}, "Internal", {QA Initial Date}, Year=2020)) and =AVERAGEIF({QA Type}:{QA…
    Accepted
    17 4
    Accepted Answer 17 views 4 comments Most recent by Stephanie Kiecker
  • Project Schedule - automate Header Status
    In Formulas and Functions
    Hi, We are new to Smartsheet. We are migrating our project implementation schedule to Smartsheet. One of the gap we have is that Smartsheet does not calculate the header status automatically. See cell in yellow below. The current formula d…
    Answered - Pending Review
    25 3
    Answered - Pending Review 25 views 3 comments Most recent by Anne-Solene Monrouzeau
  • DateOnly YearDay off a day Time Zone Question
    In Formulas and Functions
    Hello. I have a question about the DateOnly and YearDay functions. Please see below (Pic 1). All dates after 7pm gets moved to the next day for the DateOnly and YearDay functions. I am assuming, not 100%, this is a Time Zone issue as I liv…
    BD Profile Photo BD
    Accepted
    30 10
    Accepted Answer 30 views 10 comments Most recent by BD
  • More than one range
    In Formulas and Functions
    Hi gurus! I am having trouble with multiple SUMIFS. I have tried nesting them, but there must be an easier way. I need to sum the cells in the GW and CGW columns when people manager=yes. Can anyone help? I feel like the answer is right…
    16 views 3 comments Most recent by Andrée Starå
  • Changing the format of a the Created (Date)
    In Formulas and Functions
    I wanted to have a date when a task was added so I am using the Create (Date) under system-generated column. "See Below" but I only want to display the date not the time. I was looking away to format the cell so it would show onl…
    Accepted
    13 5
    Accepted Answer 13 views 5 comments Most recent by Andrée Starå