-
SUMIFS with CHILDREN Help
This discussion was created from comments split from: Sumifs and Children.
-
Task Health Calculation using duration and % complete
I am working on a formula to calculate task health with R/Y/G harvey balls based on the duration of a task and the % complete. I have found several community discussions around this but the ones I have found , I have not been able to successfully tweak to work in my sheet. In my sheet, I have Start Date, End Date,…
-
COUNTIF the values is lesser than today's date
Hi Folks, I would like to count the names with respective to dates in another column which is lesser than today's date. I used the below formula: =COUNTIFS([Projected CM1]:[Projected CM1], <=TODAY(), [CM1]:[CM1], "Flextronics Wuzhong CM") But it doesn't give the right result, any leads please advise Thanks! Raj
-
formula to add a checkbox in one column if another column is updated with multiple items?
If a column is set up as multiple drop down options, I’d like a formula in another column (checkbox) to check the box if more than one selection is made. Is this possible?
-
How to take statistics from a sheet using multiple drop down list to narrow search results
I don't know if my title made any sense, I really only know the basic jargon of google sheets. I'm using a sheet to track my day trading. I have data validation drop-down-lists for multiple variables such as: date, win/loss, type of win, type of setup, and many, many other market variables. When I make a trade, I select…
-
Extract word(s) after \
Hi, I have a long text string and need to extract the word (or words) after the rightmost "separator", which is a " \ " (space forward slash space). It's in the format text \ text \ text The number of words is not consistent in the text string (hope this makes sense)
-
Harvey Ball Status between % numbers
I want to use the Harvey Balls to flag a status as follows: 70% or less = RED greater that 70% and less than 100% = YELLOW 100% = Green what I've written: =IF([% Complete]@row < 0.7, "Red", IF(AND([% Complete]@row > 0.7, IF([% Complete]@row < 1, "Yellow", "Green")))) I get INCORRECT ARUGMENT SET error on this. If i remove…
-
Multiple Data range
Hello, Hope you could help me. How can I get data for Closed AND Scheduled? I can get "Closed" but I also wanted "Scheduled". They belong in only one Column. My formula is below. =SUMIFS({Rev FIle 10.12 Database Range 1}, {Rev FIle 10.12 Database Range 2}, "Tere", {Rev FIle 10.12 Database Range 3}, "Closed", "Scheduled",…
-
Counting a Unique Name in a contact list that has more then one name in it
I have a contact column called "Team". A task will have multiple unique names in the "Team" cell that is working that task. I want to count how many task people are working on at the parent level for the task. I have a helper filed that list the level for a task called "Level" I found this formula on another post but I am…
-
Copying columns to additional sheets
Good Afternoon, I have a sheet where information is submitted using a form. When a row is added, a unique identification number is attached to that row. I have separate sheets that are used for the investigation into the incidents/hazards reported in the form/rows. I would like some of the columns to be automatically…