Unparseable Error


Good morning,

I'm new to Smartsheet. I'm getting an error when I add the following formula. I'm trying to get it to return the current project phase that is less than 100%. Do you know what I'm doing wrong?

=IF([% Complete]37<100%,[Task Name]37, [% Complete]54<100%,[Task Name]54, [% Complete]75<100%, [Task Name]75, [% Complete]91<100%,[Task Name]91, [% Complete]101<100%,[Task Name]101)

Thank you,

Rachel Shelton

Best Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    Hi @Rachel Shelton

    I hope you're well and safe!

    Try something like this.

    =IF([% Complete]37<1,[Task Name]37, [% Complete]54<1,[Task Name]54, [% Complete]75<1, [Task Name]75, [% Complete]91<1,[Task Name]91, [% Complete]101<1,[Task Name]101)

    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.

    Did that work/help?

    I hope that helps!

    Be safe and have a fantastic weekend!


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

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!


    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.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    We will also need to incorporate some additional IF statements:

    =IF([% Complete]37<1,[Task Name]37, IF([% Complete]54<1,[Task Name]54, IF([% Complete]75<1, [Task Name]75, IF([% Complete]91<1,[Task Name]91, IF([% Complete]101<1,[Task Name]101)))))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!