-
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…
-
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…
-
Formula to return a checkbox on Sheet B, if a % column in Sheet A = 100 + move rows
Hello there, I have 2 sheets: Sheet A - Base File, where i have % Column where i input the current numbers. Sheet B - Transfer to File, where i need to add a checkbox to a row, if the % Column in Sheet A is 100 %. I have managed to make the reference where: =IF({Base File Range 5} = 1, 1, 0). BASE FILE TRANSFER TO FILE My…
-
Trouble with long date formula
Hi, I am working on something that will tell staff when the open window for a visit is, based on the visit category. Rule 1: Visits in the category of 1, 2, 3-5, 6-10, and 11+ years should be annually and the window is their DOB +/- 1 month. This portion of the formula works. Rule 2: 3rd trimester visit should start 197…
-
Month and Year output as text
Hi everyone, I need to generate a month and year from a date (text month, not number) For example, 1/1/24 becomes 'January 2024'. Specifically, I need the day removed. Is there a more efficient way than this formula: =IF(MONTH([Date Column]@row) = 1, "January", IF(MONTH([Date Column]@row) = 2, "February", IF(MONTH([Date…