-
Help with Formula for Counting Unique Values
I created a tracking spreadsheet for our annual law school on campus events and on this spreadsheet, we list within the same column all of the attorney participants we send on campus for that law school. There's usually between 1-4 attendees per event and within each row. If there are multiple attendees for that event,…
-
Count distinct values based on other cell criteria
I have been able to figure out how to count distinct values in a column. Now I would like an additional complexity of asking the formula only to count cells if it meets the criteria in another column. If the value in the Status column is 'Live', count the distinct number values in the UniqueDiseaseID column.…
-
INDEX/DISTINCT with multiple criteria
Hello, I am trying to create a formula that will pull in a distinct text with multiple criteria. I do have a helper column. The original formula I used works in a different scenario where only one criteria is met. =INDEX(DISTINCT({CLT}), Number@row) But now I want to create one that pulls in "SegAddy" when "RTRD" box IS…
-
Looking for Help on multiple criteria IF formula using full columns
Hoping someone can help: If conditions meet the below criteria, then Program Health result be be "Red" if not result would be "Green" 1st Requirement: Column "Essentiality" = "No-Go" 2nd Requirement: Column "Status" has at least one "Red" OR Column "Status" has 3 or more "Yellow" Sorry I am new to smartsheet and struggling…
-
Count IF function not working
Hi, I am trying to create a count if function that will count all the cells that include text in a row, but not if that text is "NONE" or "CURRENT REQ" I've gotten this far, =COUNTIFS(Taleo11:[Media 5 Request]11, OR(@cell = "NONE", @cell = "CURRENT REQ")) but the formula keeps returning 0 no matter what is in the row. Can…
-
SUMIFS Formula Returning 0
Hello, I have sheet where I am trying sum the total number of hits in the month of January if the text in one column matches text in a rand of cells on another sheet. I am using =SUMIF(Title:Title, CONTAINS(@cell, {Cafe}), [# of Views]:[# of Views]) just to count the total number of hits. I am usi8ng =SUMIF([Last Viewed…
-
sum if and match range of cells in
Hello, I am trying to sum rows in a column if a text in 1 column matches text in a range in another column. And have that number show up in a Summary field. If we look at the sheet, I want to sum values in the "# of Views" column if the data in "Workspace Title" match a range of cells in the Workspace column. So the…
-
Converting University semester weeks into calendar dates
Hello, Can you help me convert University Semester Week Numbers into calendar dates? Can I use a conversion sheet to do this? For example, Spring Semester begins January 17, 2023- week 1. Can week one be converted to January 17, 2023? Thanks!!
-
COUNTIFS Formula
Hi I am using a COUNTIF formula to count the number of projects, from my central intake sheet, that belong to a particular portfolio, have one of two status and belong to a particular programme e.g. Bus. Ops. Portfolio, Premises Programme with a submission status of Prioritised or Approved - Awaiting Prioritisation. The…
-
Need text response in cell if criteria are met or not.
Greetings- I have 6 columns with symbols. I have a working formula if all 6 columns have a green check the column before shows the words "All Approved" and the cell goes green. This works just fine. What I cant get to work is if one of the columns has a red X or more then one red X the first column reads "Denied" (and the…