Formula Question

Katrina W

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?

Paul Newcome

If your % Complete column is formatted to be a percentage, you will need to replace "100%" with 1 (no quotes).

 

=IF([% Complete]@row= 1, 1) 

Katrina W

thank you so much!!!  it worked 

Paul Newcome

Happy to help! 

 

Smartsheet stores percentages as a fraction of 1, so

 

100% = 1

75% = 0.75

50% = 0.5

25% = 0.25

0% = 0

and everything in between.