# Simple IF function not working

Options

Hello,

I have an issue with a simple IF formula. Here's the formula: =IF(Completion1 = "100%", "Closed", "Open") for Overall Progress Column.

It's not working. Even if the value is NOT equals to "100%", the value showing is the false one (Open). I don't know why it's not working.

A note: The logical expression (Completion column) I am evaluating counts the average of checkboxes marked across a row. Does this mean the IF column does not work in marked checkboxes?

Please let me know if you have alternatives or suggestions. Any ideas are much appreciated. Thanks so much!

• Options

It worked, thank you so much @Andrée Starå! I've been scratching my head around the formula. I'm so glad it's finally working!

• ✭✭✭✭✭✭
Options

Excellent!

You're more than welcome!

Smartsheet looks at the numbers in a column formatted for percentage as values between 0 and 1. You'd need to use decimal values instead for it to work

25% = 0,25 (0.25)

50% = 0,5 (0.5)

100% = 1

Depending on your country/region, you'll need to exchange the comma to a period.

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!