Combining 2 conditions in a calc

[gaby78]

I have 4 fields: Date, Number, Name, and AlertField:

Alert is an autoenter calc. I want it to return "Alert" in 2 cases only:

1- Date has been modified or Name has been modified -> Alert field to return "Alert"

2- Number is modified and exceeds 19 to return "Alert" (if modified and value is below 19 it's not an Alert)

I was able to figure each condition separately but don't know how to combine them.

For 1 - I have : Let ([X=Date; Y=Name]; "Alert")

For 2 - I have : Case (Number > 19; "Alert")

I have been trying to combine these 2 conditions in one expression but stuck.

AlertField is as an auto enter calc because once the person in charge has taken these changes into account the field is cleared.

[comment]

I don't see how this is possible, unless you use Get (ActiveFieldName) to identify which field triggered the evaluation. Which would mean hard-coding field names into the formula.

Alternatively, you could use two fields, one a number field with auto-entered calc =

Let ( trigger = Date & Name ; 1 )

the other a calculation field =

Case ( FirstField or Number > 19 ; "Alert" )

It's too bad you don't have version 9, because then you could use conditionally formatted text instead of the second field.

[gaby78]

Tanks Comment; I'll got ahead and use 2 fields.