Forum Discussion
The Cell Currently Being Evaluated Contains a Constant | #REF! Error
What's the advantage of building sheet Timesheet Breakdown? It is the same structure as the pivot table.
Your mistakes in Timesheet Breakdown:
You have to repeat the headers in row 6 so that the formula can pick up the correct value when copying to the right.
You have to convert the date in exactly the same format as in the pivot table: TEXT($C9;"DD. MMM")
You have to use exactly the same headers in row 8 as in the pivot table: Vacation becomes Vacation Leave and Sick becomes Sick Leave.
Personal does not appear in the pivot table. Either it is a mistake or you have to wrap the function in IFERROR().
What's the advantage of building sheet Timesheet Breakdown? It is the same structure as the pivot table.
Your mistakes in Timesheet Breakdown:
You have to repeat the headers in row 6 so that the formula can pick up the correct value when copying to the right.
You have to convert the date in exactly the same format as in the pivot table: TEXT($C9;"DD. MMM")
You have to use exactly the same headers in row 8 as in the pivot table: Vacation becomes Vacation Leave and Sick becomes Sick Leave.
Personal does not appear in the pivot table. Either it is a mistake or you have to wrap the function in IFERROR().
To show only certain parts of the data you can filter the pivot table or insert slicers and timeline for filtering.