-
Countifs with multiple criteria
Hi, I'm trying to count rows from another cell that meet the following criteria: In Progress In a specific Department The Project Manager cell is not blank I've figured out the formula for the first two, but I'm stuck trying to add the Not Blank part. Below, Range 3 is my Department, Range 2 is the status, and Range 1 is…
-
Sum a Multi Select Dropdown
I'm looking for the formula I would need to use if I have a multi select dropdown with numbers and words. I would only be looking to sum up the numbers. Some of the cells have numbers and words in the same cell. Any help would be appreciated! Thanks, Eva
-
JOIN checkboxes and text cells into one new column
Currently my formula is set up to show me text based off what cells are checked. I need to add to this formula so it will show me checked cells AND a text cell, combined. I've tried expanding the range to include Toys and that did not work. Any suggestions? Current formula for the EquipmentHelper column:…
-
CONTAINS COUNTIFS from Multi-Select Drop-Down
Hello, I've had this issue before, but forget how I've solved it. I have a formula that is trying to count an option in a multi-select menu, it cannot be a simply COUNTIFS statement and must use CONTAINS or HAS since there is more text in the cell then just one word. Here is my formula, which is appears the syntax is…
-
Should be simple CountIF
Any help on why this isn't working would be great.
-
Formula to auto-number rows for multiple projects within a single sheet
Hello, I'm looking to a formula that will auto-number rows for multiple projects within a single sheet. For example, I have rows for Project A, Project B, and Project C in the same sheet: Project A Project A Project A Project B Project B Project B Project B Project C Project C I want my auto-number column to return the…
-
PI formula
I need to reference PI for circle maths. a PI() function or a universal variable would be very useful and I'm frankly shocked it doesn't exist already. It'd function exactly like TODAY() but a number instead of a date.
-
SUMIFS with OR function (multiple criteria in same column)
Hello, I am trying to get a sum if the criterion in a certain column meets one of several conditions. If the country code equals one of the country codes in the "country" column, I would like to sum the Total MVE for each country code. Right now I have" =SUMIFS([Total MVE]1:[Total MVE]66, Country1:Country66, ="AU",…
-
Adding the number pi (π)
I'm using a sheet that needs to calculate things using circles and therefore requires the use of the number pi (π). Is there a way to express π in Smartsheet without typing it out to the full default sigfigs? 'Cause I'd rather not do that, even in sheet summary. While we're at it I'd quite like the number e as well, but…
-
Formula to add two separate columns with MONTH and YEAR criteria (blank dates too)
The formula below for March works for rows where [Date Recd] and [DateCompleted] both have dates; however, it errors out when [DateCompleted] is blank. How do I update the formula below to also sum [Received Count] where [DateCompleted] is blank and [Date Recd]'s Year = 2022 and Month = 3? Need the formula below to add…