-
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…
-
Formula help within a Sheet
Hello - we are having problems adjusting a formula to include additional details. The formula is being used on a sheet for a project checklist. The parent formula shows the overall status of child tasks - if they are all "Completed" then the formula should say "Completed", if they all say "Not Started" then the formula…
-
How can I add a reference sheet to this formula - I have build another sheet that I want to add up