-
I am having an issue with Count(Distinct(Collect returning 1
The formula doesn't error out but produces a 1: =COUNT(DISTINCT(COLLECT({Server}, {Installation_Date}, YEAR(@cell) = YEAR(TODAY() - 3), {Installed_Date}, MONTH(@cell) = 7))) I have a list of servers, the hotfixes, and the date the hotfixes were installed. So 1 server may have multiple hotfixes applied during a month/year.…
-
I'm trying to grab name from a row on a separate sheet where the row matches two criteria.
I'm trying to grab a name from a row on a separate sheet where the row contains "Completed" and the same part number. Here is the equation I'm attempting to use but get "UNPARSEABLE" =INDEX({Employee Name Column}, COLLECT({Employee Name Column}, {Part Number Column}, [Part Number]@row, {Part Complete? Column},…
-
#Invalid Data Type Error for years in rank
Trying to figure out what broke in a formula. Will you get this error if the cell is blank? For instance trying to figure out years in rank for a certain role in this example how many years from Assistant Professor to Professor
-
ERROR - #CALCULATING
Hola amigos, Por favor, su ayuda a corregir el siguiente error. He preparado una hoja maestra a partir de varias hojas utilizando la función VLOOKUP . Estuvo funcionando bien todos estos días, pero ahora en celda se muestra como #CALCULATING se resalta a continuación. **Translated to English via Google Translate** Hi…
-
IFTEXT vs something for numbers not just text
Hello Community, I am using an IFTEXT function to automatically check a box in one column if the cell in another column(s) has text in it. I also need it to check the box when the other corresponding cells have, not only text, but numbers as well. Is it possible to combine the functions to allow for an "OR" command that…
-
Highlight rule/Conditional Format?
Hello, Is there a way to highlight a row that hasn't been edited after a certain period of time? Thanks, Nathan
-
Trouble building formula with "number of stars"
Hi, I am building a training feedback analysis for my team, but having difficult with the formula to count the "star". Looking the columns: I have no difficulties to turn the value 4 (in content satisfaction column) into 4 stars (star column). However in the Sheet Summary, the first field is an average from the Content…
-
SUMIFS Using Multiple Combinations of Critera
Hi, Apologies for the (probably) terrible and non-specific title- I'm really struggling to summarise what I want to do concisely! I'm trying to create a 'summary sheet' which performs a calculation on some data using criteria which the users selects from drop downs, see screenshot below: Assuming the user must select…
-
Error adding month when going into next year
=IFERROR(Recurs@row = "Monthly", (DATE(YEAR(Due@row), MONTH(Due@row) + 1, DAY(Due@row))),IFERROR(Recurs@row="Annually",(DATE(YEAR(Due@row)+1, MONTH(Due@row), DAY(Due@row))))) Works like a charm until a date in December would happen in January, then it throws an error.
-
How to compare four cells for text to return a value
[ENG Svc Ctr]@row [PERMIT Service Center]@row [LAND Svc Ctr Code]@row [BID Location Code]@row