Hi!
I had 3 tables where they have several columns with this kind of expression:
The โTRUEโ value gets the [Y/N], where I change the subject values to Spanish (No/Si), and โtable data localโ is set in Spanish.
TRUE/FALSE values in the spreadsheet are automatically translated in Spanish, in all 3 spreadsheet tables when the value is add by the App.
IF(
[PDV9]=โTRUEโ,5
,0
)
The weird thing is that the expressions are working fine in one table, but they are not working at all in other two tables.
All expressions are simple as the example above, some of them are decimal or number type column, in the spreadsheet columns are set as automatic with 1 decimal digit.
Two thing you could try:
Donโt quote TRUE
and FALSE
.
[PVID9]=TRUE
Donโt compare a Yes/No value to TRUE to determine if itโs trueโitโs entirely redundant. This is sufficient to check whether itโs TRUE:
[PVID9]
To check whether itโs FALSE:
NOT([PVID9])
Solve it thanks
User | Count |
---|---|
36 | |
31 | |
28 | |
23 | |
18 |