Combining Multiple IF Statements

Kendrick Hanny

I have combined multiple IF Statements into one formula but I am receiving an #UNPARSEABLE error. Please let me know where my mistake is in my formula. Thank you in advance for your help.

=IF([Status]@row=“Complete”,1,IF([Status]@row=“Not Started”,0,IF([Status]@row=“In Progress”,.25)))

Andrée Starå

Hi @Kendrick Hanny

I hope you're well and safe!

You had slanted "" so I'm guessing that you wrote out the formula in Word or similar.

Try something like this.

=IF([Status]@row="Complete",1,IF([Status]@row="Not Started",0,IF([Status]@row="In Progress",.25)

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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Kendrick Hanny

@Andrée Starå you are such a great support to the Smartsheet Community!!! Thank you for all you do. That fixed my issue! Have a good weekend.

Andrée Starå

Hi @Kendrick Hanny

I hope you're well and safe!

You had slanted "" so I'm guessing that you wrote out the formula in Word or similar.

Try something like this.

=IF([Status]@row="Complete",1,IF([Status]@row="Not Started",0,IF([Status]@row="In Progress",.25)

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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Kendrick Hanny

@Andrée Starå you are such a great support to the Smartsheet Community!!! Thank you for all you do. That fixed my issue! Have a good weekend.

Andrée Starå

@Kendrick Hanny

Excellent!

Thanks so much for the kind words, and you're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!