Hi team, I have a question related to conditional formatting of text based on a field which calculates a total percentage

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

This is the formula im using on a formula-text field:

If([Total Score]<70,"<font size=20 color=red><b>Text 1</b></font>",If([Total Score]<90,"<font size=20 color=yellow><b>Text 2</b></font>","<font size=20 color=green><b>Text 3</b></font>"))

But this formula doesn't update the formula-text field based on the value of [Total Score] field as it updates. How can i resolve this?

Photo of Akhilesh

Akhilesh

  • 12 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,548 Points 50k badge 2x thumb
If Total Score is a Percentage then you need to compare to 0.70 and 0.90.

Also, while your formula will work, your Excel mindset is showing.

In QuickBase it's best not to nest the IFs, just to have fewer brackets for easier debugging..

If(
[Total Score]<0.70,"<font size=20 color=red><b>Text 1</b></font>",
[Total Score]<0.90,"<font size=20 color=yellow><b>Text 2</b></font>",
   "<font size=20 color=green><b>Text 3</b></font>")