I'm trying to import some information that was originally done on an excel sheet. On the excel sheet they have four columns that they would just put an X in if the statement was true. (were they willing to travel to area 1, 2, 3, 4)
On the database that I'm importing to I've created a field which I've just named travel and put a checkbox value list with each of the 4 areas.
Is there a calculation I can use to say if there is an X in area 1 field check this option in the new field, etc. (they could have possibly an X in all four of the old fields)? It's just there are nearly 1600 records I would prefer to not have to fix manually.