IF function 100% Complete

mmac
mmac ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hello,

 

I'm trying to figure out using a symbol column type, once the visual symbol of a checkmark is selected, to then have the % complete column populate "100%". I can't seem to figure out the correct function to apply to all cells under the symbol column to automate this action.

 

Any help on accomplishing this is greatly appreciated!

Capture.PNG

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!