formula compilation help
I just need some direction on how to compile an if type formula: I have a questionnaire with a list of approx 20 "Yes" "No" "N/A" options in each (drop down list) I want to create a quick formul...
Forum Discussion
Okay. Here you go.
Create a formula-text field and use the below formula.
Gaurav
Create a formula-text field and use the below formula.
If([Your drop down field]<>"", If([Your drop down field]="No","Non-compliance", "Compliant"),"")Thanks,
Gaurav