Formule

TVP ALAN

I have a general list with all data in

In that list i have a column Location

Those cells are filled in when we scan a location.

i want to make a new sheet inside smartsheet where i can see which location are still free.

So i uploaded all the location numbers in a column , this column needs to be cross checked with the data sheet and the loaction which are still free

Near the location numbers needs toe be column where i can see 0 or 1.. See below

So the cells in green and the column wher eyou can see 0 are the location which are still availble

Thanks

Paul Newcome

I would suggest a COUNTIFS with a cross sheet reference.

=COUNTIFS({Data Collection Sheet Location}, @cell = [Primary Column]@row)

TVP ALAN

Hi

=COUNTIFS({PB Stocklist LOCATION}; @cell = [Primary Column]@row)

i am doing someting wrong

TVP ALAN

i Dont know what happen but its ok

Thank s

Paul Newcome

It looks like the {Cross Sheet Reference} hadn't been properly set up, but glad it is working now.

Happy to help. 👍️