Formula using Symbols and Check Box

Hello everyone, I'm trying to set up an equations to do two things:

1) When the check box is click (Complete column)

The Status will change to a BLUE dot (Status column)

2) When the check box is not click (Complete column)

The Status will change to a GREEN dot (Status column)

Can this be done? Right now I'm changing the symbols manually



Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!