-
Multiple Nested If Statements with Numbers
I'm trying to build a scoring system based on the number of times a new submission came in for different sites at my company. I have a form set up to feed into a sheet then have a background sheet with a countifs formula to get the number submitted each quarter. From there, I need to change this raw number into a score…
-
Need Formula: Per Facility per Model #, how much +/- from par level.
I need to add a column formula within the Stock Inventory Sheet, in the Qty. Above/Below Par column, that calculates per Facility per Model #, take the quantity from Order Type Stock Order Row – Facility Specific Part(s), how much above or below are we from the Par Level? So something along these lines: Per Facility, Per…
-
Formulas for a range of dates in relation to today.
I am trying to rollup data to summarize how many projects have a completion date in the next 30, 60, and 90 days. Currently, I have them set up like this. =COUNTIFS({2021 Strategic Plan Initiatives Master Range 2}, <=TODAY(30)) =COUNTIFS({2021 Strategic Plan Initiatives Master Range 2}, <TODAY(60)) =COUNTIFS({2021…
-
copy rows automation with date formula
I have two sheets - one with routine tasks, the other with a list of assigned tasks. I have an automation built into the first sheet to copy rows to the second sheet on a regular basis. The first sheet has a date column which uses the TODAY() function. I'm having a problem with items appearing on the second sheet with the…
-
[Row Name]MATCH
Hello, I want to refer to a Range that is the CHILDREN of a certain row, but the row number will move around depending on adding/deleting rows. I'm hoping to use MATCH to search for a unique string to return the row number. I know that a traditional cell reference such as [Column Name]Number will adjust if I add a row, but…
-
Vlookup person on other sheet, return reference if a date falls between 2 other dates
Hi all, I need help with the following: I need to find the contract reference of a person from Sheet 1 in Sheet 2, based on the name of the person and when the mission took place. As you can see below, James had a mission on the 16th of April, so I need the contract reference that corresponds to that date, which would be…
-
COUNTIFS with reference another sheet
Hello, I'm looking for the right sentence to count the lines from a second sheet how meets my criteria. This one doesn't work: #UNPARSEABLE =COUNTIFS({Inventory Asset - Africa & Middle East Range 1}, ([TYPE]1:[TYPE]56,"Physical",[WARRANTY EXPIRATION]1:[WARRANTY EXPIRATION]56, "EXPIRE IN 24 MONTHS")) I just want to count…
-
Assistance w/ automated Checkbox based on multiple conditions
Hi All, I'm after some assistance regarding a formula to automate a checkbox based on multiple conditions. These are; Column "Requested by" is populated with a date. Column "Site" is populated. Column "Site contact" is populated. Column "Quantity" is populated. Column "Product" contains the word "Device" Then a sum is used…
-
VLOOKUP Confusion
I'm very confused about how VLOOKUP has been implemented. * Can the search value reference a value in another column in the current row, or can it only be a string enclosed in quotes? If it can only be a string, it makes the function pretty useless because I'd like to be able to lookup information based on data entered in…
-
Matching two Columns using a Checkbox
Hello! So I need to check two columns for matching names and then check if another column has two different answers and check a box. I want to check a box if the names and date matches: I've tried a few times but it's not working for me. Any ideas? THANK YOU!