App Formula for column is not working

[anonymous]

Hello,

I’m trying to make a “person status” changes whenever a “job status” changes

so here is a scenario example:
New job have a status of (Pending) and assigned to (TOM)
(TOM) status should change to (ASSIGNED)
otherwise he should have a status of (Available)

both data type is “enum”

Unfortunately the code is correct but appsheet is not computing the formula for some reason

any Help is appreciated !!!

here is a screen shot of my code

*Ignore the phrases available and not available

[anonymous]

Update:

I guess it computing the results before the user makes an input to the data, is this normal???