using IF together with AND


Sorry in advance if this has been answered but I have searched and cannot see the answer but I am sure its simple!

I have target finish and actual finish columns, in the status column, I want to report "in progress", "overdue" and "Complete"

I have got  "in progress", "overdue" to work by the following: 

=IF(TODAY() < [Target finish]3, "In Progress", "Overdue")

What I am struggling with is how to have return "Complete" if the "Actual Finish" column has a date value.

Thanks in advance.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!