How do I get a Yes/No to remain blank if there is no data entered in my fields yet

10/16/20
Accepted

My formula is: =IF([Contract Expiration Date]@row > [Date Completed]@row, "Yes", IF([Contract Expiration Date]@row < [Date Completed]@row, "No"))

If there is no Date Completed entered, it still reads as Yes. How do I make it such that if the Date Completed is blank, so is the formula field?

Best Answer

Answers

Sign In or Register to comment.