Help with Multiple IF/THEN in one formula

jcismesia76271

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!

Andrée Starå

Hi,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

jcismesia76271

Thank you Andrée

I am attaching the screen shot which will show the columns.  I also show you the second half of the formula in the "On Time" column.  

 

Thanks

Jeannie

Paul Newcome

I'm thinking something along the lines of...

 

=IF([Project?]@row = "yes", IF([Actual Complete Date]@row > [Target Complete Date]@row, "NO", "YES"), "")

jcismesia76271

Paul - that worked perfectly!!  Thank you so much!

Paul Newcome

Excellent. Happy to help!