IF, AND, ISBLANK

Options

Hi,

If cell A1 = "yes", AND if cell A2 is any value, return "Complete", otherwise return "Incomplete"

Help with that formula?

Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!