2 Replies Latest reply on Oct 19, 2018 2:42 PM by Deepak Rai

    Conditional formatting if string values match on different dates

    Ryan Lynch

      I am using one data source that has a snapshot date field on it to differentiate partitions. For each row value, I have two columns showing "Current Week" and "Previous Week". The text values used are Low, Medium and High. If the values from previous and current week do not match, I want both values to be highlighted red.

       

      I tried the following:

       

      IF ([Hiring Priority] WHEN [Ds] = '10-11-2018') = ([Hiring Priority] WHEN [Ds] = '10-18-2018')

      THEN 'GREEN'

      ELSE 'RED'

      END

       

      Anyone able to help with my calc field here?@