IF condition

[aditya_glp]

I have written an IF expression and when I click on ‘Test’, I get the expected result. But the same result doesn’t get reflected in the app screen.

Please help!

[Aleksi]

Please share the formula itself, thanks.

[aditya_glp]

Hey. Here’s my formula –

IF(IN(USEREMAIL(),TN_mapping[ASM Email]),LOOKUP(USEREMAIL(),TN_mapping,ASM Email,State),LOOKUP(USEREMAIL(),KA_mapping,ASM Email,State))

Formula explanation -

IF this condition is true:
…(USEREMAIL()) is one of the values in the list (TN_MAPPING[ASM Email])
THEN use the value of:
…One randomly chosen value from this list (
…The list of values of column ‘State’
…from rows of table ‘TN_mapping’
…where this condition is true: ((The value of column ‘ASM Email’) is equal to (USEREMAIL())))
ELSE use the value of:
…One randomly chosen value from this list (
…The list of values of column ‘State’
…from rows of table ‘KA_mapping’
…where this condition is true: ((The value of column ‘ASM Email’) is equal to (USEREMAIL())))

[Aleksi]

Are you using an app formula with normal column?

[aditya_glp]

Yes, I’m using the above condition in ‘app formula’ for a normal table’s column.

[Aleksi]

The possible reason is simple. It won’t recalculate it if you don’t open and save that record. If you create a new record, does it work then?