-
Single drop down 3 selection ( open, closed, cit). How do write formula to count each in column?
Status - Column Heading Open - Drop Down Closed - Drop Down CIT - Drop Down Wanting to count how many "open"
-
nested countif with date criteria
I'm trying to do a countif statement that checks if a request is approved or denied, and the return to work date is great than today's date. I've tried multiple ways and can't figure it out. Any ideas?
-
Is there a way to have a contingent question on a form?
I am wondering if I can have a secondary question become "live" on a form based on an answer to a question?
-
IF and HAS and OR formula combined (or alternative)
Formula wizards! Can you help me with this one? I have a column for Primary Team (single select) and a column for Secondary Teams (multi-select). I want to drive a report widget to include rows where a certain team, let's say "Team X", is either primary or secondary. Report parameters won't let me do this (because I also…
-
Help with cross sheet references.
Good morning, I am looking to pull the data in a cell if two other criteria are met in other cells in the same row. for example, I have a sheet called Daily reporting that is receiving form submissions. I want to pull the text in [Quality-Details] if [Column17] is equal to today AND [Value Stream Leader] is equal to Sergio…
-
Range with multiple columns with COUNTIFS
One range in my COUNTIFS formula has several columns included. If I use this range on COUNTIF (no S on it), it works perfectly but, when I include in COUNTIFS, it does not work. (#Incorrect Argument Set). I then split all these columns in one range, criterion and now does not count anything. Do you have any information on…
-
Formula using <>
I'm trying to create a formula that will return a red, yellow, or green ball. I saw the below formula on someone else's comment a while back, but wasn't able to find it today. Right now my formula is: =IF([Late Tasks]@row > 0.75 * [Total Tasks]@row, "Red", IF([Late Tasks]@row <> 0.5, "Yellow", "Green")) Can someone tell me…
-
Sumifs Adding multiple criteria
Good morning, I am trying to add up total hours of a {Project Type} Column if the project type contains the following: Implementation, Implementation - Small Market, and ELD Implementation =SUMIFS([Hours Worked]:[Hours Worked], Date:Date, >=TODAY(-7), Project Type:Project Type, "Implementation", "Implementation - Small…
-
IF Formula Issue
Hey all! This is so simple but having issues. I want to show "1" "2" or "3" for "Low" "Medium" "High" =IF([Level of Change]@row, = Low, "1", IF([Level of Change]@row, = Medium, "2", IF([Level of Change]@row, = High, "3") What am I missing?!
-
Does COUNTIFS work with only 2 conditions?
Ive been trying to add multiple conditions in to calculate some values for my Sheet Summary, but I cant seem to add more than 2 conditions. Each of them work individually & with 2 conditions, but when i add the third condition it always shows '0'. What am i doing wrong? The formula I'm using is: =COUNTIFS([Overall…