Help with Multiple IF/THEN in one formula

edited 12/09/19 in Smartsheet Basics

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!