Formule

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

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

I would suggest a COUNTIFS with a cross sheet reference.

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

TVP ALAN

=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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.