3 Replies Latest reply on Sep 11, 2018 5:55 AM by Ivan Muccini

    Replace values in existing column based on a condition

    Ivan Muccini


      I have a column where I need to replace the value with another string based on the result of comparison of 2 other columns. for eg,

      The value in Segment should be replaced by "New Group" if Ship Mode = "Same Day" and Country = "United States"


      I wrote the following formula. but I get an error "Filters must return a boolean value". but the formula I wrote returns a string.

      IIF( [Ship Mode]= "Same Day" AND [Country] = "United States" , 'New Group' , [Segment] )


      Could anyone help me rewrite the formula in a way that would result in replacing a value with another string value in an existing column?