IF Formulas including Blanks and AND / OR



I'm looking for a formula that will show me whether a deadline has been met.

My Deadline Met formula is currently only taking into account the Agreed Deadline Date and the Date Completed =IF([Date Complete]@row <= [Agreed Deadline]@row, "Yes", "No")

However, what I really need it to do is also check if a). There is a date in the Renegotiated Date and if there is, is this date <= Date Completed.

The use cases are:

As a job completer

I want to select Complete once I have completed a job allocated to me

So that the date completed can be recorded

As a supervisor

I want to be able to see whether a deadline was met, whether it was an originally agreed deadline or re-negotiated date

So that I can track how many jobs are being completed on time

Hope that helps




Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!