Hello,
I am new with excel. I have a daily task report sheet attached. If user enters a date in the Task End Date in Collumn L, then the Status in collumn N should change automatically to Completed.
I also need help to create weekly pivot table report which can be shared showing tasks, status, total number of tasks, etc.
The required fields (highlighted in yellow) that needs to be displayed in the pivot table are:
1. Task Description
2. Task classification
3. No of Hours
4. Status
5. Remarks
6. Finally the total number of Tasks should be displayed below. This is the total number of values in Task description. Say there are 5 tasks, then total should be displayed as 5. Note, the report is to show weekly status
Appreciate your help and expertise.
Thanks and Regards,
Santosh
Bookmarks