-
Looking to compare two dates to create an Integer value across sheets
Hello, I am looking to create a tracker that tells me the quantity of samples that arrived in the estimated time against the actual time. My thought process was you have two date columns Date Column A (estimated date) and Date Column B (actual date). I would in my raw data sheet create a link to Column B first than compare…
-
Formula help with COUNTIFS
I know this must be a simple change but can't for the life of me figure it out! I'm just looking for End dates greater or equal to TODAY where the status is not "complete". This isn't working :-( =COUNTIFS([Expected / Actual End Date]:[Expected / Actual End Date], >=TODAY, Status:Status,<>"Complete") Thanks in advance!
-
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…
-
Automatically drawing data from another sheet? Vlookup? Index?
Hi brainstrust, I'm trying to match up some population data from a different sheet with a humanitarian response distribution tracker. So if a volunteer enters "Sydney" in a row regarding their latest trip then the population is automatically entered from the other sheet. I've tried to use IF but there are way too many…
-
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…
-
How to add Checkboxes into IF(AND formulas.
I'd like to be able to pull in when a checkbox is marked off in another sheet. Sheet 1 has multiple Project IDs. Associated with each project is a checkbox to indicated whether the scope of the project will be impacted. Whenever a checkbox is marked off for a project in Sheet 1, I want to capture that in a separate sheet.…
-
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…
-
Forumla to calculate the percentage (%) change between two dates
Here, I am seeking to capture the % change between original finish date vs actual finish date. Example dates are as such: Original Finish Date = 3/1/23 Actual Finish Date = 4/15/23 What is the percentage change in the date difference? I would like to calculate this to speak to owners of task saying "hey, you deviate from…
-
Need workflow help
I have been fighting with an approval workflow triggered by a new line, based on dollar ranges, and an established DOA (delegation of authority) hierarchy. Is someone able to help? Maybe a screen share session? Tell me what needs to be done to arrange that. Thanks!
