14 Replies Latest reply on Sep 24, 2015 3:24 PM by erolst

    Imported excel file fields help - setup new calculation




      I've recently imported an excel file (with old bento info) into filemaker. All great!


      But: we used to have several fields with colours, and you'd either input "0" or "1" depending if the item had the colour within it or not (we're talking clothes here). Is there a formula I can create in order to sort this into 1 column only? Instead of having 0 and 1 values for every colour under the sun?


      I've attached a print screen.