Can % Complete return a "COMPLETE" Value in Status

Options

I am working with a construction schedule and the Project Manager manually enters the % Complete. I created another column called status and what I would like to do is when the PM marks 100%, the status column automatically reads Complete. And if they mark anything under 100%, the status column reads Incomplete. Is there a formula for this? It seems like it should be easy to figure out but I'm clearly missing something.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!