I am trying to create a fomula field in Quickbase with and If statement so that I can just stick that form on the Exact form. I am just not good at formulas in general.
This is basically what I am trying to say:
If the option chosen in Ship To2 is "Shop", Display the result in field " [Shop Address2]"
The formula I have, which is obviously not working is below. Can someone please tell me what I have to do to get this to work?
[Ship To2]="Shop" ," [Shop Address2]",
[Ship To2]="Project","[Project – Location]",
[Ship To2]="Customer","[Project - Customer - Address] ",
[Ship To2]="Other”, “[Address]")