I have below expression;
I needed it to show record belonging to the current user in the app,
It should not display records that have been treated and OFT_Comment is empty value
AND([created_by]=USEREMAIL(), ISNOTBLANK(OFT_Comment), [status]<>'Treated')
The issue now is, it is still displaying records which have no record OFT_Comment column
Solved! Go to Solution.
Try to use..
AND([created_by]=USEREMAIL(), ISNOTBLANK([OFT_Comment]), [status]<>'Treated')
Try to use..
AND([created_by]=USEREMAIL(), ISNOTBLANK([OFT_Comment]), [status]<>'Treated')
It worked, Thank you Aleksi
Good to hear!
User | Count |
---|---|
42 | |
26 | |
25 | |
17 | |
13 |