Forum Discussion
KevinSlider
7 years agoQrew Trainee
Do you want a different warning for each company, for each warning "type"?
...
If([BSS Vendor #]<>"","",
Case([Company],
"ABC Food Service","ABC Food Service Vendor Number",
"ABC Kitchen Construction","Construction Vendor #",
"BSS Vendor #"),
....
...
If([BSS Vendor #]<>"","",
Case([Company],
"ABC Food Service","ABC Food Service Vendor Number",
"ABC Kitchen Construction","Construction Vendor #",
"BSS Vendor #"),
....