Hello All, duration column circled in blue is automated as per the project setting circled in red is all manual I know weeks cant be determined from entering dates so i entered weeks manually in actual duration column and it has set the dates, but the roll up is in days is there a formula I can use on another column to…
I am working on a project where I want to use a formula to return the date of the last Monday in a month. For example, if I have a cell that says 4/11/2024, I want a formula that will then return 4/29/24 (because that is the final Monday of this month).
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? Formula I have used in Next Review Date column =DATE(YEAR([Last Reviewed Date]@row) + [Review Frequency]@row, MONTH([Last…
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: if % complete = 0 and start date is today or in the future, then stage is grey and status is "not started" if % complete =…
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 this case branding # to have their own lines and I do not want to have to put in all this data. Sometimes we have up to 100 or…
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 & pulling it back, but it is not formatting the column as a "contact" - it looks like plain text (no contact "circle") This is my…
I have lots of passengers on separate rows. I have a heading row of dates. I then have a sequence of 1's in a grid that show which nights a person will check in for 1 over night stay. In the first example, my traveller will check in on 17/06 and check out on 24/06. I am currently having to update the columns manually when…
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 Intercompany", ServiceCustomerName@row, CustomerName@row)
Below is the source sheet destination sheet
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