Problem with IFS() use

Hi !
I want to use a multiple conditionnal function for my column [Sigma] with IFS().

[Sigma]'s column type is a decimal and not a date…So I don’t understand why it send me this message.

Thank you for your help on this topic. :ok_hand:

2 Likes

Please try removing double quotes around the resulting decimal values in the expression. In general. double quotes need to be used for text values. You could possibly try removing quotes around % values as well if those are percentage columns.

Please see the article below. @steve has nicely explained the issues with double quotes for decimal with examples.

3 Likes

Nice @Suvrutt_Gurjar

In addition, decimals are with dots in AppSheet.
Commas are of local use in France :wink:

4 Likes

Yes true @Aurelien

1 Like

Thank you all, it works now !

4 Likes