-
Issues with Cross Reference and VLookup
I have been trying for several days to get cross referencing to work, it is stuck in the processing status is what I have noticed. I even tried to use different browsers to see if that was an issue. In order to provide data for testing, I cut down my files to remove sensitive data and just included the necessary data, now…
-
Pull cell value based on matching value in two sheets
Hello all, hoping someone can help me with this question. I need to pull a cell value into Sheet 2 based on a shared cell value in Sheets 1 and 2. Specifically, I need to pull the value from the MIN Score column in Sheet 1 to the row with a matching COSMOID in Sheet 2. For example, Client A has COSMO ID 123456 and a MIN…
-
Nested IF formulas
Hello, I'm new round here. Please excuse the entry level ask. I have an array of 3x3 cells. In each row only 1 of the 3 cells will be completed and I want to return a value from another cell depending on which of 2 the 3 cells are blanks. I have these 3 formulas working as expected in isolation, but I am struggling to nest…
-
Filter by formula
I have several columns which I typically have a formula in nearly every row (like you would use a column formula) but I've decided to have the formula be cell based because every once in a while, I need to input a manual number instead of deriving from a formula. My current situation is that I'm using reference manager to…
-
Breakdown formula not working correctly
Hi All, So I've got this formula that automatically breaks hours down into respective columns based on dates: =IFERROR(IF(AND(VALUE(YEAR($[MDR Start]@row) + "" + IF(MONTH($[MDR Start]@row) < 10, "0") + MONTH($[MDR Start]@row)) <= [Jan-21]$1, VALUE(YEAR($Finish@row) + "" + IF(MONTH($Finish@row) < 10, "0") +…
-
Help with project metric and resource setup
we are not using Resource Management because it is way too manual of a workflow to manage. Instead I am trying to replicate some level of a resource map by doing the following: there is 4 stage gates that are the primary workload impact for various teams with a specific Start/End for each stage. Team 1 = Stage 1, Stage 2…
-
Nested IF formulas for status
I am trying to write a nested IF formula, but as I run it there is one argument that is not resulting as I expected. Basically what I want my Status column to represent is the following -Done: when a project is in 100% compliance -In Progress: when a project is anywhere from 1%-75% and its within the due date (the…
-
metric sheet and sumif formula
Hi I am having a tough time with a sumif formula on a metric sheet. =SUMIFS({Location # and Name 4}, LOCATION@row, {AP $ AMT POSTED}) I am wanting to count by location the $ in the AP $ AMT POSTED column. Any help is appreciated.
-
Shorter way to do this?
I am using a formula to change the value of one cells based on the values of some cells below it in a column. The formula that I'm using is working but I want to add it to some more places in the sheet, where it would get very long. Does anyone know a way I could abbreviate this? It is okay when there are only two cells…
-
Issue referencing VLOOKUP data in another formula
Hi, I have a VLOOKUP pulling in data from another sheet that will be updated on an ongoing basis. The data pulling in is the number of manufacturing days to complete an operation. The VLOOKUP function is working fine. This is the VLOOKUP formula: =VLOOKUP([Model Series]@row, {Mfg Hours by Model Range 1}, 7, false) Within…