-
How do you calculate overdue dates?
Hi, I am creating a sheet to maintain our fleet. I have a column with the registration and a column with the Tax and MOT due dates. I need a formula to calculate the number of dates that are overdue for the summary but everything I try isn't working. Does anyone know a formula for this? Thank you in advance.
-
Creating a mastersheet
Anyone can help me to create a mastersheet to pull in info from several sheets? eg I need a total on the mastersheet to be reflecting a tally from the individual sheets. So column total in sheet 1 and sheet 2 = total in sheet 3 (mastersheet)
-
I am trying to use sum ifs another sheet column is between dates and equal "spm"
=SUMIFS({Sofia}, ="SPM", {Sofia (Shawn) 2021-22 YTD},AND({Sof}>=(2021,8,1),{Sof},<=(2021,8,31),{Sofia (Shawn) 2021-22 YTD}))
-
RYGG formula
Hi Guys, I have an RYG formula that adjusts the ball colour - =IF(Finish@row - TODAY() > 7, "Green", IF(Finish@row - TODAY() >= 3, "Yellow", "Red")) I also have a grey ball so I want to automatically tie the grey ball to the status COMPLETE. How do I do this? Any guidance is much appreciated. Barry
-
Cross sheet Index/Match with row deletion or addition
Apologies if this question has been posed before, however I have not been able to find a solution by browsing through the community (there is also a good chance I'm approaching the problem incorrectly). I have started building a master project sheet that contains several columns with project related information. I would…
-
Sheet linking and URL display
Currently, I know how to link to a URL using the right click method on a cell. This also allows a URL to be covered by a "Display Text" Can the same thing be accomplished by entering a string into the cell, similar to how it is done in HTML? This would allow for more efficient linking and design possibilities within a…
-
Symbols for Status
Why are my words not translating through to symbols? The formula seems to work since its returning the text, but ist converting it to symbol form =IF(Status@row = "Assigned / Not Started", "Empty", IF(Status@row = "In-Progress, On-Schedule", "Green", IF(Status@row = "Delayed", "Yellow", IF(Status@row = "Complete", "Blue",…
-
What is the formula that I will need to track how many completed projects an employee has worked on
Here it the formula I was trying but I kept getting an #INVALID REF. =COUNTIFS({DCIM Projects 2020-2021 Range 1}, ="Complete", AND({DCIM Projects 2020-2021 Range 2,="Susan ****"})) (Replaced employees last name with * for privacy) We have a few projects that take multiple employees and some that it is individual. I am…
-
Help with Index/Match
Hello! I am trying to put together a formula that I could use some help on. I have 2 different sheets, Boarding Passes and Open Cases. In Open Cases, I have a Case Number. In Boarding Passes, I have a Case Number(s) field that could reference more than one of the case numbers in Open Cases (these should be separated by a…
-
Reference Predecessor Cell / INDIRECT Function
I'm using a formula to automate a status column that updates based on dates and/or a "Complete" checkbox. The formula has to reference the task before and I've gotten that to work just fine if it's the literal task before. My problem is that I'd like to adjust the formula so that it references a predecessor task (as…