-
Formula to display one date in a range with 3 criteria
Hello everyone, Can you please help me with a formula? I have three columns: 'Start date' , 'Dose', 'Site'. I would like to consider multiple criteria: 1) the start date is in the future 2) the value in the 'Dose' column is 'drug' and 3) the Site is '01'. Based on these criteria there should be a list of dates, but I would…
-
Incorrect Argument set with IF and VLOOKUP
Here is my formula - =IF(Activity@row = "Field", VLOOKUP(Employee@row, {Employee Payroll Info Range 2}, 9, false), IF(Activity@row = "Bakery", VLOOKUP(Employee@row, {Employee Payroll Info Range 2}, 8, false))) I am trying to determine which hourly rate to use based on activity performed.
-
Calculation from Sheet with shuttled Data to combined data
I have a sheet that is refreshed every morning to add and update existing data from an in-house data warehouse. I am trying to create a sheet that pulls from the original sheet and can produce a graph in dashboard that tells me how long something has been in a current state, with many things being in that state for various…
-
If then Formula help
Hello! Looking for help with my formula that would enter the text "complete" if the checkbox column was checked and if the checkbox column was not checked it would subtract the due date from today's date to get days remaining. Here is my attempt at a formula - thank you for the help! =if([Data Received]@row, 1 =…
-
Count IFS & Contains
I'm trying to count the number of times a specific string of text is referenced in a column on another sheet. I've tried multiple ways, but it doesn't seem to come out right - =COUNTIFS({KPHI: SHP Master Patient Tracker_ProcType}, "TAVR", {KPHI: SHP Master Patient Tracker_Comp@Proc}, CONTAINS("Arrhythmia, 1st Degree AV…
-
HELP!
I am trying to match asset number hours that automatically come in via form and pull them into a separate data dump of current inventory. I only want the highest value since the number of hours are reported daily.
-
I am trying to get a unit count between a date range.
I am trying to get a unit count between a date range. I have two difference columns from one sheet and two difference columns on my main sheet I am referencing. I keep getting unparseable. Is there a way to to get the number I want with using the countifs formula? Or should I be using a different formula? This is the…
-
COUNTIFS formula for any future date?
Hi all, I am trying to create a COUNTIFS formula that counts if the due date column on another sheet is today or any future date. I tried =COUNTIFS({due date column's range}, >=TODAY()), but it is not working. Any advice would be appreciated! Thank you.
-
Converting MM/YY into MM/DD/YY for date column
I had searched on here a couple times and tried some of what I found, couldn't get it to work. I have the date imported in MM/YY format as a text column. I'd like to have a date column next to it, with MM/DD/YY, with the DD being the last day of the calendar month. Am I aiming too high?
-
How to index /match that has multiple dates- but I want the latest one
I have read so many index/match, max/collect, and index /collect questions, and all of them seem to be just a little different than what I need, and I can't figure this out. So I have two sheets, one data sheet that I am pulling from based on criteria from another sheet. Except the data sheet has multiple entries and I…