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


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!