-
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?
-
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…
-
Dynamic year formula for the previous year
Hello! I would like to show the average score for the previous year without indicating specific year (instead of showing 2023 I use formula (YEAR(TODAY()) – 1. =AVG(COLLECT({Vendor Evaluation Sheet - Archive - Score}, {Vendor Evaluation Sheet - Task ID}, [Task ID]@row, {Vendor Evaluation Sheet - Archive - Created},…
-
VLOOKUP formula pulling data from another sheet
I'm using the VLOOKUP Formula to match the "Application" in table 1 to "Application Name" in table 2, then return the "Primary Product Family" from Table 2, Column 2 to "Program" in Table 1 where the formula is. =VLOOKUP(Application@row, {Applications}, 2, false) What I'm I doing wrong?
-
How can I bring cell values from one sheet into another sheet "multiple values cell"?
Below is the source sheet destination sheet
-
anyway to create formula for matching current user to cell contact list value
I've tried multiple things, even making them select a dropdown on the top row so the "modified by" for that row captures their name then using another column with contact list property with the formula "=[modified by]@row" for the remaining rows. But even this fails since in the "standard" contact list dropdown my name…