AnsweredAssumed Answered

Calculation Help

Question asked by Annette on Sep 5, 2013
Latest reply on Sep 5, 2013 by RehmanAkram


Calculation Help



     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.