Need help making this formula work

Options

I want to add to this formula that if Entered in Oracle Date is Blank, INCOMPLETE will populate in the First Shift Entered On or Before First Shift field. My current formula: =IF([Entered in Oracle Date]@row <= [First Scheduled Shift]@row, "YES", "NO"). How can I add what I am looking for?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!