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 DropdownIn Formulas and FunctionsHey 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…
-
How to change formula for more then one criteriaIn Formulas and FunctionsSo 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…
-
COUNTIFS not working correctlyIn Formulas and FunctionsI 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…
-
COUNTIFS function showing errorIn Formulas and FunctionsI 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]…
-
Sum a column of numbers only if they meet certain criteria.In Formulas and FunctionsI 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…
-
Avg of a range with 2 criteriaIn Formulas and FunctionsHi! 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…
-
Project Schedule - automate Header StatusIn Formulas and FunctionsHi, 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…
-
DateOnly YearDay off a day Time Zone QuestionIn Formulas and FunctionsHello. 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…
-
More than one rangeIn Formulas and FunctionsHi 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…
-
Changing the format of a the Created (Date)In Formulas and FunctionsI 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…