Hello I am trying to create a report to show actual complete date success vs. target complete date success at the project level (my row hierarchy is Category>Project>Task). So I figured I needed to create a column called On Time? that compares cell Actual Complete Date vs. cell Target Complete date. But I only want to do this analysis at the Project Level (so project level rows only)
The formula would do - If Project? cell value is "no" or blank then leave On Time? cell blank, but if Project ? cell value is "yes" then perform another if then formula (comparing if Actual Complete Date cell> Target Complete Date cell, if yes, then value is "NO, if not, then value is "YES".
Thanks for the help!
