Symbol Data Type

Sebastian Avila

Hi everyone i´m trying to use symbols with formulas =IF([KPI REQUERIMIENTO]1; <=2; "Green") and i´ve been getting #INVALID DATA TYPE as result. Been testing with Text/Number and symbol column type and keep getting this error

Which column type should i use to get this formula working?

Thank you.

Phil Francis

I think that if you use column type RYGB balls from the Symbols menu it should return a Green circle.

I'm still pretty new to this but I notice you are using semi-colons in your formula but most of the formulae I've see use commas as the separator, so that may also be something to check.

Sebastian Avila

already using that type of column and i use semi colons, because if i use only comas it returns #UNPARSEABLE instead of #INVALID DATA TYPE.

Andrée Starå

Hi @Sebastian Avila

If you hover over the symbols in the selector, you can see what it should say. I suspect Green is wrong for your region.

Did that work?

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!