Using AppFormula and Initial Value

AppSheet AppSheet Q&A
1

Hi. I am using an IFS statement on a column that sets the value to ‘Yes’ based on any of a number of conditions being true but I want its value to initially be ‘No’ and remain so until one of the IFS conditions are met. I set inital value to ‘No’ but doesn’t seem to be working. Can I set an initial value for a field with an App Formula? If not what is the best way to achieve my requirement?

Thanks.

2

Instead of IFS(...condition..., "Yes"), just use ...condition.... Use it as the column’s app formula.

3

Thanks @Steve. Just so I understand. By removing the IFS and leaving the condition only the app formula will auto set the field value to No until one of the conditions are met?

4

Correct.