Newish to SharePoint so, hopefully, I am explaining this clearly.
I want to build a simple Timesheet List where I have the following columns:
- Employee Name (Choice column, drop down of employee names)
- Vacation Start (Number column, is the number of total vacation hours a specific employee has)
- Vacation Taken (Number column, is the number of vacation hours a specific employee has taken)
- Vacation Earned (Number column, is the number of vacation hours a specific employee has earned per month)
I realize I can total these columns these by going to Modify View then the "Total" section in the list setting. And filtering by employee name...
But, what I also want is a column called Vacation Balance that would add all the total earned days (Vacation Earned) to the Vacation Start column then subtract all the total Vacation Taken days for each specific employee.
Example. Employee Alen has Vacation Start = 100 Vacation Earned = 8 Vacation Taken = 40
So therefore Vacation Balance would be 68 for Alen.
I tried a calculated column with =(Vacation Start + Vacation Earned)- Vacation Taken but the variable always shows a -variable for whatever shows in Vacation Taken.
Any suggestions? Thank you in advance.