#INVALID DATA TYPE error with IF function

Allie Forbes

I have set up a separate column to convert my progress bar values to numbers to be used in downstream calculations. This formula works to convert "Empty" to 0, "Quarter" to 0.25, "Half" to 0.5, and "Three Quarter" to 0.75. However, if I change the progress bar to "Full", the error #INVALID DATA TYPE appears instead of converting "Full" to 1.

=IF([% Complete]1 = "Empty", "0", IF([% Complete]1 = "Quarter", "0.25", IF([% Complete]1 = "Half", "0.5", IF([% Complete]1 = "Three Quarter", "0.75", IF([% Complete]1, "Full", "1")))))

Does anyone have any thoughts on why I am getting this error? Thank you!

Andrée Starå

Hi Allie,

You’re missing the the equal sign before full. You used a comma instead.

Try this.

=IF([% Complete]1 = "Empty", "0", IF([% Complete]1 = "Quarter", "0.25", IF([% Complete]1 = "Half", "0.5", IF([% Complete]1 = "Three Quarter", "0.75", IF([% Complete]1 = "Full", "1")))))

Did that work?

I hope that helps!

Be safe and have a fantastic week!

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!

Andrée Starå

Hi Allie,

You’re missing the the equal sign before full. You used a comma instead.

Try this.

=IF([% Complete]1 = "Empty", "0", IF([% Complete]1 = "Quarter", "0.25", IF([% Complete]1 = "Half", "0.5", IF([% Complete]1 = "Three Quarter", "0.75", IF([% Complete]1 = "Full", "1")))))

Did that work?

I hope that helps!

Be safe and have a fantastic week!

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!

Allie Forbes

Thank you Andree for pointing this out to me!

Andrée Starå

You're more than welcome!

Happy to help!