Hello there,
'm having problems using the IN function.
Solved! Go to Solution.
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.
Could you elaborate what you mean by the following? The column type and values you are expecting.
@AndreaSangalli wrote:
appsheet does not give me the same value.
I don't understand why i have TRUE in the test mode and FALSE in the column.
Could you please share the screenshot of the [Email Check Scenario] column's expression screenshot?
This is the Expression for [Email Check Scenario]
In case it's relevant to your situation: If the Y/N column already had a value (e.g., "N") in each row in the data source, then revising the column's App formula expression won't affect those existing values. Rather, the revised App formula expression will only apply to a given when it's invoked for that row--e.g., when the row is edited, thus triggering recalculation of its columns.
i Went in test mode to investigate why the value doesn't match and this is what i found.
the column was empty when I start to test the expression
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.
Thank you very much!!
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |