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 | |
32 | |
25 | |
23 | |
14 |