Count column Text from Sharepoint

(1) Share

Report

Posted on by MiniMax92

151

I have a sharepoint list in which specific storage locations for each item are assigned. As an example:

Item Nr.	Item	Manufacturer	storage location
1843288	PC	Apple	3-112
8834254	Smartphone	Samsung	8-64
3545882	Headphones	Apple	3-112

This table has over 2000 entries and needs delegated forms.

I now want to know which storage location contains fewer than 10 items in order to add new items to the storage location.
Count formulas cannot be delegated and are out of the question. Unfortunately I didn't find a useful formula.
It is also important to mention that storage location is formatted as text, but that shouldn't be a problem.

Maybe someone has an idea what I could try? 🤔

Categories:

General Questions

All responses (1)

Answers (1)

Verified answer

MiniMax92 151 on at

Like (0)

Report
Count column Text from Sharepoint

I have a solution:

// Label2_1 is the storage location in my gallery With({ds:Filter(MySPList; Storage location = Label2_1))}; CountRows(ds) )

have fun :D