Hello AppSheet Community
I would like to exclude all rows from a data slice where the value for the column “R Number” is blank.
So I tried using a FILTER() expression to create my data slice, but AppSheet did not like that the FILTER() expression returns a list.
Then I tried using the expression ISBLANK([R Number]), but it did not remove the columns it was supposed to.
Then I tried ISBLANK([_THISROW].[R Number]) but then the slice returned absolutely nothing.
I’m out of ideas. How do I remove the rows with a blank value for the R Number column?
Thank you AppSheet!