I need your help regarding the โIFโ condition.
I have two columns, the BV1 (Enum with a value of Yes and No) and the BV1 Score(Number).
Formula in [BV1 Score] is IF([BV1] = Yes, โ20โ, โ2โ). On the first entry, the formula works and logs to the data source correctly, but when we update the same field, the formula works in the AppSheet but not updating correctly in the data source.
Please see the below screenshot:
***BV1 Score should be โ20โ
What is in your BV1score column I canโt see it in your pic?
I find it weird that you didnโt put quotes around Yes, but did around number values.
IF( [BV1] = โYesโ , 20 , 2 )
Also, do you know about Yes/No type columns?
Yes, I know the Yes/No type columns. The client doesnโt want to use it for this app due to the button. It says No - Yes, instead of Yes - No.
Interesting. I never thought about the order being an issue. I just experimented on this, and it worked. Add this to the Yes/No columnโs valid_if to affect the order:
LIST( TRUE, FALSE )
User | Count |
---|---|
42 | |
29 | |
25 | |
23 | |
13 |