I have a column with a drop down where you can select multiple options for one cell. It is tracking who is affected so it can list multiple departments. I want to track by department so I am trying to…
Hi, I have a formula that adds 1, 2 or 3 years onto a date but the return date is going to the 1st of the month. Can someone please advise how to fix this so the date is exactly 1, 2 or 3 years later?…
Hello! I am working on a column formula for a project plan where the RYGG ball and Task Status will automatically be updated based on the % complete and the due date. What I'm trying to solve for is: …
Hi. Is it possible to auto populate rows based on the number I have in my QTY cell? I want when I enter a 3 in the QTY cell it automatically copies and adds those three lines. I need each of the in th…
Hello everyone - thank you for your help. I am having some challenges with an Index/Match formula that populates a Contact List type column from a cross-sheet reference. It is finding the data & pulli…
I have a formula to say if a certain row contains a value then use another columns data instead. I want it to do the same if the cell is blank. This is what I have so far =IF(CustomerName@row = "NCR I…
My goal is if total number of students is 0 then it should equal number of students then in Total students the formula will be total number of students minus number of students
I'm trying to get a count of all cases that are not complete (aka open), to use on a dashboard metric widget. Eventually I'd probably like to be able to have a metric widget showing the count of cases…
Hello, I have a large sheet that we use for procurement for our company. Employees use a form to requisition items, and then when I place the order for them I input the date ordered into a column. Ano…
I'm trying to create a formula that is only triggered when today's date is between two dates. Otherwise, I want it to be blank. I want the dates to be in the cells and not just in the formula. I use t…
