-
Adding Values across sheets
we have a Survey response sheet that has a column with total minutes for each setup we are trying to calculate the Average minutes by adding all the Values and divide them by the total of records. I have a Dashboard calculation sheet and Im trying to add all the numbers of minutes in the column so I can dive it by the…
-
Help with MAX Function
Hello, I need help writing a MAX formula to return information by the latest creation date. My current formula is =IFERROR(INDEX({CS PT Recruitment Candidate FirstName}, MATCH([Workday PID]@row, {CS PT Recruitment PID}, 0)), ""). If we recruit for a position multiple times in a fiscal year, the position ID remains the same…
-
Populating a field when two checkboxes are checked
Hi all, I'm just starting to learn more about formulas and am a little stumped on this one. I have two columns that are checkboxes: "Dates Received" and "Prices Received". When both checkboxes are checked, I would like it to populate a field in another column with "1". When neither are checked, or only one is checked, I…
-
Need to edit this formula & I can't figure it out
Hi, I am using this formula in a dots column (red, yellow, green). We are measuring completion for training. There is a 5-hour training and a 25-hour training. Originally, the 5-hour had to be completed by the end of August but apparently that didn't happen. So we had it set up that if 5-hour AND 25-hour is complete, it…
-
Is it possible to tweak COUNTIF to count everything but a certain criteria?
Here's my function that works when conditions are met: =COUNTIFS(Name:Name, CONTAINS("Open", @cell), Location:Location, "TBD") How can I adjust this so that it works when I want it to count cells where locaton isn't "TBD" -- putting in all the options of possible matches isn't feasible. I've tried the NOT funtion, but must…
-
COUNTIFS formula for tasks due between 8 and 14 days in future
I'm trying to write a formula to count the number of tasks due between 8 and 14 days in the future. I started with a formula that is working for the number of tasks due in 7 days: =COUNTIFS({Schedule - % Complete}, <1, {Schedule - End Date}, <=TODAY(+7)) I could repeat the formula, replacing the +7 with +14, but I don't…
-
VLOOKUP/IF Formula Question -- What's the best way to accomplish this?
Hi all, I'm struggling with utilizing an if statement with a lookup table in a reference sheet. I've tried a few different combinations and all return an incorrect argument error. To be honest, I'm not sure that utilizing either of these functions is my best route to take. This is what I want to accomplish: If the Date…
-
COUNTIFS Formula based on Dates
I'm trying to use the COUNTIFS Formula to count a range that has to be greater than 0 as well as within a certain month. I've gotten a formula to work but it would be cumbersome to implement in any way. Has anyone done this with success?? It would look something like this: =(COUNTIFS({Kettle 1}, AND({Month}, DATE(2020, 10,…
-
pin the home or recently opened menu
I would love to be able to pin the "recently opened" or home menu to the left of the screen, so it stays open while I am in a sheet or report. There are frequent occasions where I want to be able to navigate around and it requires extra clicks.
-
folder colors & organization
Maybe this exists, but I haven't figured it out... I'd love to be able to color code or otherwise visually organize the folders and files within a folder.