KWright84✭

Hey there. I'm wondering if it's possible to set the duration of a task and then the WINDOW of time in which you'd like the task to be completed. For example, I want all members of the project team to complete a training video that only takes one hour, but they have a window of two weeks in which to complete this training.…

Please add my vote, whether to apply formatting rules across multiple sheets simultaneously, or to save formatting rules as a template that could be applied to new/existing sheets.

Thanks so much! That also worked for me.

FYI, I tweaked the criteria and fixed the formula, if anyone wants to use something similar. =IF([Anticipated Project Launch Date]@row >TODAY(), "Gray", IF(OR(AND([Anticipated Project Launch Date]@row <=TODAY(), [Deviation from Proposed Launch Date]@row >= 100, [Completion]@row < .5), [% Remaining Resources]@row < 0),…

Hi Andrew, I'm no longer getting the INCORRECT ARGUMENT ERROR, but now I can't seem to get the order right. No matter how I set it up, one of the colors doesn't work. =IF([Anticipated Project Launch Date]@row >=TODAY(), "Gray", IF(OR(AND([Anticipated Project Launch Date]@row < TODAY(), [Deviation from Proposed Launch…

[email protected]

Hi Paul, I'd love to hear about the workaround! I'm willing to get as complex as needed to solve this problem and ensure the work being logged is against the specific tasks, rather than just making people write the task in themselves. I'm imagining adding another column to the project page for "Work Hours" which is updated…

The winner is: =IF([Anticipated Project Launch Date]@row >=TODAY(), "Gray", IF(AND([Anticipated Project Launch Date]@row 31, [Deviation from Proposed…

This worked: =IF([Proposed Product Launch Date]1 < TODAY(), "Gray", IF(AND([Proposed Product Launch Date]1 >= TODAY(), [Deviation from Proposed Launch Date]1 < 100), "Green", IF(AND([Proposed Product Launch Date]1 >= TODAY(), [Deviation from Proposed Launch Date]1 > 31, [Deviation from Proposed Launch Date]1 < 100,…