I am really having trouble around here.
I have 2 SharePoint list items, one is the populated list from entries of employees and the other is a submission monitoring of the first list showing the total number of submissions per location in each column.
I used the second list as a lookup for the first and select multiple selection possible.
Its easy to count the [Generated] column if the lookup I used on List no.1 is not multiple selection but once multiple selection is selected, the count is not possible anymore using the lookup procedure. This is where I am having a hard time.
- I need help for any work around to count the other columns on list no.1 and have it appear on list no.2
- If the location mentioned in list no.2 did not select on each column on list no.1, I want to monitor that as well as [None Selected].
I will appreciate any assistance on this.
Thank you very much.