-
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…
-
Averaging RGB balls
I'm hoping this is quite simple, but my simple mind is struggling to piece it together. I have a Parent Row with multiple Children but only one hierarchy below it and i want the parent row to average the status of the Red, Green and Blue balls on the Children rows...make sense? Help would be much appreciated, screen shot…
-
3+ Levels of Filter Groups
I know I've seen this filter setup before but I cannot seem to recreate. I am trying to layer 3 or more filter groups to attain the desired logic. Is this feasible?
-
Unwanted Default gray background of the dropdown selections
Hello, I am trying to change the backgound color of the Dropdown selections that appear in the cells to white. Is this possible? is there any CSS formatting i can give to the background of the dropdown selections? I would like that gray background gone please
