-
[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!
-
Filtering Columns in Reports
I have a master sheet which has data pertaining to different departments. From this master sheet, I'd like to show only the information relevant to a department to that department, and none of the other data. 1) How do I restrict the datas in the columns that have to be shown 2) If out of 4 child rows, 3 pertain to one…
-
Nested SUMIFS each with multiple criteria
Hello, Diving right in to the problem at hand. I have one sheet that handles reagent requests from multiple departments and another sheet that contains all of the stock solutions these reagent requests are made from. I want successfully created a formula that works for 1 sumifs scenario. =[Request Vol (ml)]@row -…
-
Solved: Subtracting time using formulas
Published Time of Day Conversion and Calculation sheet https://app.smartsheet.com/b/publish?EQBCT=6d765f7f8a864676b3b5d5f8fd866bf1 Original "Subtracting time using formulas" thread https://community.smartsheet.com/discussion/3795/subtracting-time-using-formulas @Shawn Roberts @J. Craig Williams I searched for "Subtracting…
-
COUNTIFS in a Date Range
I'm attempting to count how many times a sales rep's name appears in a column and the deal they're working on will be closed within a date range. I'm using a countifs statement with an AND for the criteria on the second range. I receive an INVALID OPERATION result when I use AND, but if I only look for either greater than…