trouble with if then statement

I am wanting to setup a IF then statement, so when the percentage of cell A is 0 or 100, cell B changes from Not Started to Complete. I am using the following formula, which I adapted from MS Excel but it doesn't seem to be working. I am doing something wrong because it is not working.

=IF([% Complete]15 = 100, "Complete", "Not Started")

Note: Cell B is a drop down column, Cell A cell seems to be formatted to %, since I only have to put in 100 not 100%.

Thanks



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!