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!
Please share the formula itself, thanks.
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())))
Are you using an app formula with normal column?
Yes, I’m using the above condition in ‘app formula’ for a normal table’s column.
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?
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |