-
Current Month Spending Formula
Hello Community, How do I calculate how much was spent this month using the below columns? [Spending Date] Date Format [Spedning Amount] USD Format Something like =SUMIF([Spending Date]:[Spending Date],(MONTH(TODAY())), [Spedning Amount]:[Spedning Amount] The Issue is that (MONTH(TODAY())) returns the current month in a…
-
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…