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”