I am trying to change(Substitute) a value to be shown

I am trying to change the value to be seen to my user when a certain value is given.

When “+” shows up in my raw data I want “Positive” to be shown in my app. I cannot seem to make this happen. Here is my current expression:

SUBSTITUTE([Antigen], “+”, “Positive”)

The error it gives:
The filter condition ‘=SUBSTITUTE([Antigen], “+”, “Positive”)’ of format rule ‘Positive Color Code’ must return true or false.

Solved Solved
0 11 530
1 ACCEPTED SOLUTION

Sure, you can also use this formula.

IF([Antigen] = “+”, “Positive”, “Negative”)

View solution in original post

11 REPLIES 11
Top Labels in this Space