Run a formula if a cell is "not" blank


My formula exists in the Left Before Training Started column. I'd like to return if a cell in the Leave Date column is blank, return a blank. If it is NOT blank, I want to determine if the date in that column is before the date in the Training Start Date column. If yes, then return the word "BEFORE" to indicate they left before the training started.

Why is my formula not working!

=IF(ISBLANK([Leave Date]@row, "", ([Training Start Date]@row < [Leave Date]@row, "BEFORE"))

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!