I have a list of locations that i am trying to make a formula derived from a current field. but naturally i have about 100 locations that then have corresponding regions , so i would have 3 statemen...
yes so i think best way is to just export it into excel and the Vlookup , add the new column to parent table , and call it done. Didn't think outside the box(quickbase)