Count Each Row with a similar Status

[daniel_sanchez]

Hi, I have an App that scans the material that receiving in my warehouse and too scan the delivery to the assigned carrier. When we scan it, the app shows what carrier he will receive.

So, when the material is delivered I did create a module for this, in this module first the user has to select the correct carrier and if he doesn’t do it the app does not allow scanning. this allows continuous scanning of the same carrier

what I try to do now is create a virtual column that shows the count of all skid of the same carrier that remains in the warehouse, these must be status “load Recibido” or “load in Transit”

when scanning the delivery, the user can know how many skids are left from the same carrier having pending to scan and As you scan the account, the count is subtracted

example:

I am lost with the formula for this, as this need filter only the load (rows) that have a status of In transit or receiving but not others status.

thank you for your help

[Marc_Dillon]

If I understood correctly, maybe something like this:

COUNT( FILTER(
  loads ,
  AND(
    [carrier] = [_THISROW].[carrier] ,
    IN( [status] , LIST( "load recibido" , "load en transito" ) )
  )
) )

help.appsheet.com

COUNT()

Number of list items

help.appsheet.com

FILTER()

Select rows of table or slice

help.appsheet.com

AND()

Are all true?

help.appsheet.com

IN()

Is item in list?

[daniel_sanchez · Accepted solution]

you’re awesome, the formula works perfectly!!

the scan to delivery is another table but just relate the virtual column with this formula:

and now:

thank you very much, solved!!