Formula Question

Katrina W
Katrina W ✭✭
edited 12/09/19 in Formulas and Functions

I would like the column "Done" to be checked automatically if the % Complete is  changed to 100%.  I am using the formula below which is not working:

=IF([% Complete]3 = "100%", 1) 

Any suggestions?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!