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 re…
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 …
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…
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, wit…
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 Shee…
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…
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 - …
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 …
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 formul…
