Using IF to look at a Checkbox field and return "XYZ"

PStowers
PStowers
edited 12/09/19 in Formulas and Functions

I am creating a Status field using IF function.  I'm trying to look at a check-box field and return  "status" (ex. "Tooling Complete") if the box is checked.  I've tried IF(NOT(ISBLANK(... but a check-box formatted field seems to register as not-blank whether it is checked or unchecked.

 

Does anyone know a different function I can use in this case?

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!