Hello
Good night, I've been trying to create a dynamic color, in which I put this code:
#ff7373 is red
#5ac18e is green
#E7E7E7 is gray
if(int(${perc1}>100), "#ff7373",
if(int(${perc1}<100), '#5ac18e','#E7E7E7'))
if it goes beyond 100% it's a color
if it doesn't pass it will be another
can you help me to understand why it never goes out of the gray color?
thanks
Solved! Go to Solution.
Hi
Your brackets were incorrectly placed.
if(int(${perc1})>100, '#ff7373',
if(int(${perc1})<100, '#5ac18e','#E7E7E7'))
This fixes it.
You can attach your XLSFile to your question. It will help you get answers. Upload a simplified version of your survey to keep things easy.
Hi
Your brackets were incorrectly placed.
if(int(${perc1})>100, '#ff7373',
if(int(${perc1})<100, '#5ac18e','#E7E7E7'))
This fixes it.
its work, thanks