cooper collier 3/2/2019 2:24:34 PM HI. If all you wish to do is assign or display the value, it is pretty easy. Create a formula column, if you want % use a formula text. You then use the Case formula. when I make a case formula I always format it so its easier to understand. Formula ignore spaces and line returns, Case( [ITEM], "books",0, "Carriage",20 ,9999 ) Each line is a combination of, "what you are comparing", "what to set the column" the very last line, is optional and is for what to use if none of the above compares did not find anything. The last line should not have a coma. do not forget the ending parentheses. Look in the formula manual. https://www.teamdesk.net/help/13.3.aspx. TIP, when I compare text values, I always surround them with Lower([Item]). Because the compare can be case sensitive, so I just make everything small. |