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

[Tiger1]

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.

[JuneCorpuz]

Tiger:

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

What property are you applying this formula?

[Tiger1]

Property? Where is that? I was doing this in “Format Rules”? Is that what you are asking?

[JuneCorpuz]

Yes, I’m referring to the property of the column but it seems that you are applying the formula into a format rule. I think you can use the SUBSTITUTE in the column properties because you are changing a data.

What you can do here in format rules is to change the formula into [Antigen] = “Positive”, and you will add an icon, select a color, change the property of the font such as bold, italic, strikethrough, etc.

[Tiger1]

Here is my problem. My raw data looks like this:

I am trying to change those “+” and “-” so that we can read it better in the app.

Does that make more sense?

So i cannot put:
[Antigen] = “Positive”

Because it never does in my raw data.

[JuneCorpuz]

Then just create a virtual column and apply this formula SUBSTITUTE([Antigen], “+”, “Positive”) because you are trying to change the data. You cannot change the data in format rule.

[Tiger1]

PERFECT!

Thank you so much!

[Tiger1]

Last question - can it also say “Negative” if the “-” comes up?

[JuneCorpuz]

June_Corpuz:

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

Haven’t used substitute formula, but you can try this one.
OR(SUBSTITUTE([Antigen], “+”, “Positive”),SUBSTITUTE([Antigen], “-”, “Negative”))

[Tiger1]

Thanks that didn’t quite work so i changed it to this -

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

And it worked!

Thanks again so much

[JuneCorpuz · Accepted solution]

Tiger:

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

Sure, you can also use this formula.

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

[Tiger1]

Thanks