-
SUM formula
Morning all! I'm looking for a formula that counts the total score from my team summary, as long as the team name matches and populate it here, where it will then rank their score in comparison to other teams I have tried a number of SUM formulas, and cant get one to work for me. Any suggestions? Thanks in advance!
-
How can I set a Row ID column that does not change when you move, add or delete rows
Hi all - I've been able to create a Row ID column that updates when you add/delete a row fairly well, but when rows are moved around it breaks again. Current set up: X: autonumber column Row ID: =MATCH(X@row, X:X, 0) This works ok but every time I move rows or make big changes I have to re-set the autonumber (X) column. I…
-
I am trying to create a formula with varying conditions
I am trying to create a formula for the likelihood of a project. I have 2 helper columns and a final column. I am only worried about 1 of the helper columns as I cannot get it to work. The Conditions I am missing is for when a project is planned to start in the middle of a year, I want the % to carry over until 0, and…
-
Automate At Risk Flag
Hello, I am trying to automate an at-risk flag where the flag will turn red if the item is not 100% complete at the targeted due date. Any Suggestions? Thanks!
-
Reference EACH child from the Parent on Another sheet
I want to display (from another sheet) the child rows. How can I use a formula, on each of my child lines that displays child1, child2, child3, child4, and child5 in my Release Name & Release column. I only require the ability to do this in these 2 columns. The black text is raw data (and the blue text are formulas).
-
Can I get help with a SUMIF formula for a Sheet Summary?
Is it possible to SUMIF a $ value column, based on a "this month" check box in Sheet Summary? I', using [Value]:[Value] and [This month?]:[This month?] for my columns. Thanks! Jen
-
How to count the total number of unique contacts from a contact list "allow multiple contacts"
Hi - I have a contact list column that allows multiple contacts per cell. I am trying to count the total number of unique contacts that are in this column. Attaching an image of the contact list column titled team. The answer based on the image would be 11 unique contacts. Thanks in advance for the help!
-
How to Track movement of Duplicate Code from One sheet to another one.
I have 2 sheets 1st is Asset Master sheet and 2nd is Material Movement sheet. An index match formula is implemented on Material movement sheet to get data from Asset Master sheet like Asset code, Asset name, Asset description. However there another Index match formula applied on the 1st sheet i.e. Asset Master sheet to get…
-
Combining countifs and countif into one formula
Hi all, I have a sheet which includes two separate formulas, one, a "countifs" and one a "countif". Both work seamlessly in their respective columns. However, in reviewing my related dashboard, I noticed that my "countif" column was including a row of data it shouldn't and realized that I needed to amend my "countif"…
-
conditional formatting for dates in another column
I need to make the dates in a column turn green or red depending if they are complete. There is a box of due date of the deck, the deck completion date needs to turn either green or red, based off hitting the due date or missing it- OR if the box hasn't been filled with a date when it is due. HELP, please.