I have a humdinger of a request I need to determine if it’s possible and/or more trouble than it’s worth if somebody wants to chime in
here’s the scenario
I need a field in an SP list to be built off 3 conditions
- Vendor name, which is typed in manually or by choice
- Current Year
- Number of documents we have done for that vendor in the current year
2 and 3 need to be calculated if possible. Â The name is then built based on those 3 criteria
number 3 is where I see a lot of difficulty
- Add a Vendor column to your document library.
- Add a custom view to your document library.
- Filter the view by the current year.
- Group the view by the Vendor column.
The grouping will include the Vendor’s name and the number of documents in the group.
