Sign in to join the conversation:
Hello, I need to create a health status column (RGY) that correlates to the finish date, percentage (0-100), and status (not started, in progress, complete). Please help me out with a formula because this has been so confusing.
On my sheet, I have a Planned Migration Date column that has discrete date values for each row. I have another column called "Migration Week Monday" where it determines Monday's date for the associated Planned Migration Date. My formula works well on the sheet up until I use a cross sheet formula to pull in the date value,…
Hello all. I've searched for a solution but have not found one. I am using an index match formula to return an "employee name" based on a "project name" match. The formula returns no match…but there should be. Scenario: I have a sheet which lists projects including: project #, project name, super, etc. I used a formula on…
I have a sheet that has 20 cells that are dates Due and Done for 10 categories. I have an Overdue Week column that I want to show "Yes" if a Due date is prior to current week. I managed to do that, but once one date leads to a "Yes" it never changes even if the task is completed and marked in the corresponding Done cell.…
