App Formula help

[Tony_Landowski]

We have created this app formula in our field [PrivacyCase]

Formula: "IF([_THISROW].[Incident]="bd304b15", "Yes", [_THISROW].[PrivacyCase])

It works perfectly, except if someone has already added a value to the field [PrivacyCase].  It will not change the value.  Is there something we are doing wrong?

[AleksiAlkio]

It sounds you have that formula with the Initial values. That's a normal behavior. Move the formula to App formula field and then test it again.

[Tony_Landowski]

AlesksiAlkio,

thank you.  At first, this was our issue, but we have moved to App Formula field and it is still performing the same issue.

[Denny774]

Hey man,

try this:
IF([_THISROW].[Incident] = "bd304b15", "Yes", "")

Cheers

[RobertB · Accepted solution]

Is [PrivacyCase] a Yes/No, or an Enum? Can it change throughout the course of the records life, or is it set once it's initialized?

If it's a Yes/No I'd say just use [Incident]="bd304b15". If you want it to be blank then IF([_THISROW].[Incident] = "bd304b15", "Yes", "") would work. Also you might have better luck with a virtual column. Virtual Columns constantly get recalculated, and this isn't a complex formula so there shouldn't be an issue. If you're using a physical column then it only recalculates on edits when input as a formula.

Also make sure you're putting that into the Formula field. If you're entering it into the Initial Value field, then it only calculates when the row is first created. You can also go into the column settings and enable the Reset on edit option.