I’m working on a use case where, upon selecting a week number, it currently displays all the people who worked that week. Instead, I’d like the display to show each person’s name only once, with their corresponding work details (days worked and hours worked) organized in the columns to the right. Additionally, at the end of the row, I want to see the total hours worked by that person.
Use a query to query all rows that has the same person name and week number as this row > person name and week number.
Then you can use rollups to sum up the hours as you need.
Add a single value column to get the first rowID from the query.
Only show rows that have rowID equals to single value > first query rowID, it’s kind of a unique function where you only show one row of data that represents all records for a person in a single week.
1 Like