-
Need a Formula to Count repeated values in both cells
Here India and US are repeated in both cells, hence I need the value 2 via formula. Kindly help.
-
#UNPARSEABLE when using Cross Reference
I am trying to "simply" use data from one sheet and if the cell is Yes, it then adds another Cross Reference to the new sheet. If (Cross Reference: Refile Access) is Yes, then (Cross Reference: User Name). If Cross Reference: Refile Access is no, then nothing would happen. Both cross references appears as being used so I…
-
Formula to be copied and increment the column reference
Allowing a formula that references another sheet, and to be copied via the drag function to copy this formula in column "Rating 1" =IFERROR(INDEX({Rating_Avg_Selection}, 2), "No Data") in the same row to the right (next column), and reference the next number within the formula, which will point to the correct row where the…
-
Formula for calculating the Monday before a date?
Hi all! I'm trying to create a formula that will auto-populate due dates in a tracker that we have for new hires. In one location, their paperwork must be complete by the Monday before their start date. In another location, it must be complete by the Wednesday before their start date. They may start on different days of…
-
how can I add on the roll up table my contact list of mangers so that the formula work
i have tried adding the email - the name but it doesn't work ! this is the formula I have used and referenced the assigned to and status column
-
Project Status Formula Help
I have a formula I need help with for the top level of my project checklist hierarchy. Overall Project Status - this is looking only at the highest level rows which are indicated by the helper column Hierarchy=0. The objective of the formula is as follows: If the Project Override field (in the Sheet Summary) is filled out…
-
How To Calculate Number Of Days In Month So Far
I am wondering if there is a formula to calculate the number of days in the month to date so I can use it in a formula to calculate a monthly trend. For example, by the 10th of December we have 24 closed deals and we need to calculate the monthly trend to see if we're on track to hitting our targets. With the above…
-
Sum cells with multiple options from dropdown only
Hello, I would like to sum up costs only for cells that have multiple homegrown fruits within a single month. In this example, January's sum would be $3,500. I've tried a few formulas and thought I got it with the below, but it doesn't look like it's accurate. Does anyone have any recommendations? =SUMIFS({Inventory -…
-
Symbols in Sheet Summary Pane
Hello All, Thank you in advance for your help. I have a Red, Yellow, and Green symbols column in my grid view. In the sheet summary pane I want to have a summary column that provides the minimum value of the symbols column. When I use this formula in the sheet summary, =MIN([Project Health]:[Project Health]) I just get the…
-
Moving Comments Between Sheets
I am looking to find a method to copy select columns in a row along with the row comments from one sheet to another. Methods that I have tried and will not work in this scenario: Copying the entire row from Sheet A to Sheet B (This brings over all columns and I am only looking to copy over select columns) Using helper…