I want a value in a certain field to change when the status in the other two fields changes, for example, if column one has values of yes, no , I want the value to change to yes if columns 2 and 3 are both yes, and to change to no if either of the columns is no
You can solve this with a Formula field that uses the and() or or() function depending if you need both conditions to be true or only one.
For example: I have this simple table with a boolean field and a text field. The formula field checks if the boolean field is true and the text field contains the word ‘yes’
and(field('Field 1'),field('Field 2') = 'yes')
Thank you frederik for the input .