I have few fields and the final result fields
how can I change the final result status to pass or fail if any two or three of conditions are selected as failed.
For Example: if any 3 of test is selected fail then final result is failed and if less than 3 fail selected then final result is pass
You can achieve this by adding a Formula field to automatically calculate the final result.
To make the formula simpler, you may converting the test result values into numeric values,
such as: “Pass” = 0, “Fail” = 1
Then, you can use a formula like:
IF(test1 + test2 + test3 + test4 >= 3, "Fail", "Pass")