Unparseable Error

Rachel Shelton

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

Andrée Starå

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!

Best,

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!

Paul Newcome

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)))))

Andrée Starå

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!

Best,

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!

Paul Newcome

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)))))

Andrée Starå

@Paul Newcome

Good catch! 👍️

Rachel Shelton

@Paul Newcome , @Andrée Starå , thank you for your assistance! It fixed my formula!

Hope you have a wonderful weekend!

Andrée Starå

@Rachel Shelton

Excellent!

You're more than welcome!

Paul Newcome

Happy to help. 👍️