I have a DB on my SharePoint site using several Lists. For one of the lists I need to count Total, Pending and Completed records from the other tables.
There's one list for each department and on it each user has a number of procedures they must read if the procedure has been completed then it's set to Completed otherwise will show Pending. So I need three calculated values in my Users list, Total will count the number of items for the user and will select the table according to the department. Pending will count only the items set to Pending and Same for completed.
My lists are like this:
HR (Procedure Name, Status, Name, Email) IT (Procedure Name, Status, Name, Email) Marketing (Procedure Name, Status, Name, Email) . . . Users table has the following columns Name, Email, Department, Total, Pending, Completed
So if the user belongs to the HR department then the Total, Pending and Completed columns will be fetch from that list. Is there a way to achieve this using the Calculated Value column?