If checkbox is checked, add text to cell

Options

Hello, I have a checkbox in a column named "Completed"

I'd like to have a formula that adds the number "100" to a column named "% Complete" if the box is checked.


I've read other posts and cannot get this to work. thanks!

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!