AnsweredAssumed Answered

Imported excel file fields help - setup new calculation

Question asked by LesAteliersTurcotte on Sep 23, 2015
Latest reply on Sep 24, 2015 by erolst

Hello!

 

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.

Outcomes