USE OF ISNOTBLANK FUNCTION

AppSheet AppSheet Q&A
1

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

2

Try to use..

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

3

It worked, Thank you Aleksi

4

Good to hear!