11 Replies Latest reply on Oct 11, 2016 12:52 PM by Lisa Li

    Conditional Formatting or Calc?

    Rajul Parekh

      Hi Everyone -

       

      Can't seem to figure this one out :/

       

      I want to mark a company as "New" if they haven't previously hired. In the example below, I need some way to look across the row to see whether another column is populated. If it is (regardless of what the value is) I want the last column to say Old. If only 2016 is populated, then this company would be "New".

       

      Company
      201220132014
      20152016New/Old?
      A21Old
      B1New
      C11Old

       

      Thanks so much!