USE OF ISNOTBLANK FUNCTION

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 Solved
0 3 49
1 ACCEPTED SOLUTION

Try to use..

AND([created_by]=USEREMAIL(), ISNOTBLANK([OFT_Comment]), [status]<>'Treated')

View solution in original post

3 REPLIES 3

Try to use..

AND([created_by]=USEREMAIL(), ISNOTBLANK([OFT_Comment]), [status]<>'Treated')

It worked, Thank you Aleksi

Good to hear!

Top Labels in this Space