I have a contingencies picklist. ( appraisal; title exam; proven pay history; credit report) Currently it outputs with a semicolon between each picklist value (appraisal; title exam; proven pay history)
I would like the desired output format to be as such:
If two are picked : "appraisal and title exam"
If three are picked: "appraisal, title exam and proven pay history
If four are picked: "appraisal, title exam, proven pay history and credit report"
I'm thinking I can probably accomplish this formating with a formula field?
Thanks,
Adam
2 respostas
