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 |
---|---|
32 | |
30 | |
30 | |
18 | |
16 |