-
Health formula help
Hi - I'm sure lots of folks ask for assistance with similar things, so I apologize if this has already been asked/answered; I just haven't found anything to match my particular situation. I am trying to create an IF statement that will take into account multiple columns and conditions for a grant funding project management…
-
Looking for Nested IF formula support, unless that's the wrong formula set...
Looking to get specific terms to auto-populate the "Production Status" column, based on where the current Actual production line up is done to. For example, if a date is entered (manually) for Capping Actual, then Production Status would say "Capped". If IVT/ Uncapped Actual had the last date it would say "IVT" for…
-
INDEX COLLECT with MAX and ISBLANK
Hi folks, I'm a bit stuck with this formula. Hope someone can help. I want the Link to Latest Edit column to pick up the Latest Edit for whichever project is indexed in the row. The Current formula is leveraging my Autonumber column and picking up the last added with a MAX. Like so: This all works fine except that…
-
MAX Date based on value in a Category column
Hello. I am trying to calculate MIN and MAX dates based on the value in the Milestone Category. The first screenshot is my source sheet. The second screenshot is the second sheet where I am performing the calculations. Looking at the first screenshot below, let's say I want to calculate the MAX Start Date for any row that…
-
Remove Rows That Are No Longer In Report
I've done a little bit of research and from what I'm seeing there isn't a way (but I'm hopeful you all have a workaround 😀). So I have sheets that contain multiple unique IDs for tasks (they are separated out by manager since we have so many of them) and if a task is deleted on a project plan because it isn't needed…
-
IF/Index/Match
It's Monday and I can't seem to get this one to work. If a value populates in a cell in a specific column (this is a formula column) Every row that contains this data (All the columns) it would fill in the data that's listed in the formula column.
-
IF/OR Formula
Hello - I am trying to make a formula work but having issues. I have a more significant formula that is correct but when I add to it, I mess it up and can't figure out what I'm not doing. I can make each formula work on its own but having trouble merging them. The following formula works. I need all of it but I also need…
-
If match formula
Hello! I'm trying to catch if there are any discrepancies between model homes on our manual entry vs the systems data. Model homes should be based on whether ADA is required or not. I've already created a helper column that tells me if model homes don't match but I need to add the "ADA Required?" column to my formula and I…
-
Calculating a Total Occurring within a Specific Month (SUMIF)
Hello, I am working off the provided personal car mileage tracker to create a monthly total for an employee. I am creating a sheet summary formula. My formula isn't giving me an error but it isn't calculating either! I've tried it with and without the parent/child indentation and same result. I want to calculate the total…
-
JOIN COLLECT with OR criterion?
Hello community, I am trying to put together a JOIN COLLECT formula with a criterion whose range is a multi-select dropdown menu. Right now the formula is working when only one is selected from the menu. =JOIN(COLLECT({ERT Emails}, {Status}, "Active", {Region}, Regions@row), ", ") How can I adjust the formula to pull from…