Hi, is it possible to have conditional cell formatting that’s based on multiple columns?
I have columns for Due Date and Status and I’ve got Red, Yellow, Green configured for the Due Date using:
But I also want to factor in the Status column and if the Status is Resolved or Closed then I just want the color to be green irrespective of what the actual date is.
I’ve tried adding a CASE statement as a Custom formula, but keeping getting a message that no function matches that signature:
CASE [Measures].[Issue status] WHEN "Resolved" then "tomorrow" WHEN "Closed" then "tomorrow" ELSE [Measures].[Issue due date] END