-
Help with Metric sheet
Hello, I created this metric sheet to get totals for overall performance but I can't get the totals to populate from the sheet that is being referenced. Not sure what I am doing wrong,
-
Count Multi Select dropdown values
Good evening everyone! I’m looking for some help with a formula for Multi Select drop down. I’m looking to reference another sheet and count or sum the number of values selected in a drop down multi list regardless of what has been selected.
-
Count Multi Select dropdown values
Good evening everyone! I’m looking for some help with a formula for Multi Select drop down. I’m looking to reference another sheet and count or sum the number of values selected in a drop down multi list regardless of what has been selected.
-
#UNPARSEABLE (Nested IF) - SOLVED
SOLVED! It was a DAU/Picnic error! I was missing the row number after the column name. Apologies, I'm not able to delete/close the original question. ________ I have a column named "Complexity". It's a drop-down list. The options in the drop down are: Rudimentary, Light, Intermediate, Advanced. Might you please shed some…
-
How can I adjust my formula to return a value from another sheet?
Hello, I am trying to adjust the formula below to return a value from a cell on another sheet if the room number and dates match. Here is the formula currently: =IF(COUNTIFS({All Requests Range 2}, "Beaumont 111", {All Requests Range 5}, <=Date@row, {All Requests Range 6}, >=Date@row) = 1, "reserved", " ") This formula…
-
Check all Child Checkboxes when Parent is Checked
Greetings - I am looking for a formula that will automatically check the child rows associated with its parent on a Pivot sheet. Any help is greatly appreciated. Thanks in advance! Andy
-
Applying complex formula to Column
Good day gurus, I need to apply multiple IF statements to a Column. Based on the choice made from a drop down menu, the result will return a number. The statement below works; however is not in the correct syntax for applying it to an entire column. I tried to use @Row but I am failing miserable as all my attempts are…
-
What is the nested IF formula for the following?
If a request is less than 70% complete, turn the "Status" column into a "Red" status ball If a request is 70% or above and less than 100% complete, turn the "Status" column into a "Yellow" status ball If a request is 100% complete, turn the "Status" column into a "Green" status ball
-
COUNTIF and CONTAINS and OR
I have 2 columns that have multiple select drop down options. I want to create a formula that allows me to identify a PLO and then count the number of times "BE" OR "BC" OR "BL" or "BM" appear throughout the entire sheet. so: =COUNTIF([PLO Alignment]:[PLO Alignment], CONTAINS("A.1 Environment",@cell), Sections:Sections,…
-
COUNTIF using IFERROR and MONTHs
Hello, I'm trying to count a range of cells under the Due Date column in a referenced sheet when the dates have months of October, November or December. I saw another post about using IFERROR when experiencing Invalid Data Type which is what I experienced. The formula worked when I only counted for October (Month=10), but…