Solved: IN function doesn"t work - Page 2

AndreaSangalli · 12-25-2022 07:32 PM

Hello there,

'm having problems using the IN function.

For some reason the function gives me the correct value in the TEST mode but in the actual column the appsheet does not give me the same value.

I tired to substitute the column in stead of the type value but result does not change

Thanks in advance

Screen Shot 2022-12-25 at 10.21.19 PM.png

Screen Shot 2022-12-25 at 10.30.56 PM.png

dbaum

In the expression test mode, the values displayed for each column may be the inputs to the expression evaluation (i.e., not the outputs), and an empty Y/N column resolves to false for purposes of various functions. I suggest confirm what value ends up in your actual data when using the app.

View solution in original post