Count from this row in another table everything but blanks

AppSheet AppSheet Q&A
1

Hello,

I’m trying to do a progress on an inventory count. I have zones set up and I want employees to verify or request a change in these zones. I have a virtual column set up and a new view for the people doing the auditing, and I’d like to run

Count(Select(Inventory[Is Verified?],[Zone] = [_THISROW].[Zone]))

Which works, but, I want it to count every row in column Is Verified? except for any blank columns. Any help is appreciated.

2

AND() - AppSheet Help

ISNOTBLANK() - AppSheet Help

3

I can not seem to get the syntax correct to include and and isnotblank into the expression.

4

The docs have plenty of examples.

What have you tried?

5

I’ve tried a few different combinations, most recently:

AND(
Count
(Select
(Inventory[Is Verified?], [Zone] = [_THISROW].[Zone], ISNOTBLANK(Inventory[Is Verified?])
)
)
)

I’ve also tried this, which does not error out, but it still only gives a total count of rows and not the specified:

Count
(Select
(Inventory[Is Verified?], [Zone] = [_THISROW].[Zone],
AND
(ISNOTBLANK(Inventory[Is Verified?]), ([Is Verified?]=" :check_mark: ", " :no_entry: ")
)
)
)

Maybe I’m just too dumb for this.

6

Ok,

I was able to do this with the following:

COUNT(FILTER(“Inventory”, AND(ISNOTBLANK([Is Verified?]), ([Zone] = [_THISROW].[Zone]))))

1 Like