Hello
I want to calculate a field as a function of several other fields:
The field I want to calculate is called utilisation_c. It is a simple choice list field with the option ‘YES’ ‘NO’ ‘NA’.
it will depend on a date field: reception_c and an other field : type_c
When the date filled in in reception_c is before 01/10/2024 I want the field to display ‘NA’.
When the type_c field is filled with ‘11’ I want the field to display YES
If none of these conditions are met, I want the field to be filled in manually using the drop-down list.
Is this feasible?
Could you help me find the formula?
Thank you very much for your help