Cell Formatting Issue

Questions & Answers
1

Hello,
I have this table and one of the rows is not getting colored and i dont understand why ?
image

image
image787×727 33.6 KB

Code-----------------------------------
CASE [Risk Impact].CurrentHierarchyMember.Name

WHEN “High” THEN
CASE [Risk Probability].CurrentHierarchyMember.Name
WHEN “High” THEN “dark red”
WHEN “Medium” THEN “medium red”
WHEN “Low” THEN “red”
WHEN “(none)” THEN “light red”
END
WHEN “Medium” THEN
CASE [Risk Probability].CurrentHierarchyMember.Name
WHEN “High” THEN “dark yellow”
WHEN “Medium” THEN “medium yellow”
WHEN “Low” THEN “yellow”
WHEN “(none)” THEN “light yellow”
END
WHEN “Low” THEN
CASE [Risk Probability].CurrentHierarchyMember.Name
WHEN “High” THEN “dark green”
WHEN “Medium” THEN “medium green”
WHEN “Low” THEN “green”
WHEN “(none)” THEN “light green”
END
WHEN “(none)” THEN
CASE [Risk Probability].CurrentHierarchyMember.Name
WHEN “High” THEN “dark grey”
WHEN “Medium” THEN “medium grey”
WHEN “Low” THEN “grey”
WHEN “(none)” THEN “light grey”
END
END

1 Like
2

Hi @Goncalo_Marques ,
From the formula you provided, everything looks okay and should work. But you can double-check the spelling of your Jira values for the “Risk Probability”, see if there is no empty space after the “High” and that all your values in the conditional formatting also are added without any extra spaces.
If the spelling is correct, then please write directly to support@eazybi.com as there might be some other problem that is not so easily to troubleshoot.

best,
Gerda // support@eazybi.com

2 Likes