-
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…
-
Formula issue with #NO MATCH (Using IF and IFERROR)
Hi I have the following formula: =IF(AND([Attended over 6 months]@row = "Green", Interview@row = "Green", [Referee Check]@row = "Green", [Blue Card Linked]@row = "Yes"), "Yes", IF(OR([Attended over 6 months]@row = "Yellow", Interview@row = "Yellow", [Referee Check]@row = "Yellow", [Blue Card Linked]@row = "Hold"), "Hold",…
-
Help with formula that has negative numbers
Hi, I am trying to work out a formula that would return the below # value so I can then change status in a different column 0% to 25% = "1" 26% to 100% = "2" -1% to -25% = "3" -26% to -50% = "4" -51% to -100% = 5 this is the formula that I am trying to get to work, it only gets so far and then stops. '=IF([% Completed Vs…
-
formula to exclude items
I need to make a Sum of a column "Estimated Annual Revenue" but filtering by different options that I have in a column "Provide Client Sector", for example Commercial items and excluding from other column called "Status" items with "Cancelled", "Declined" and "Implementation complete" I have this formula now working but…
