How to Group by in Appsheet

I have 3 tables as following:
Table Employees with columns Name, Email.
Table Timesheet with columns Name, Project, Time in, Time out, Total hours.
Table Projects with columns Project, Total Hours.
How can I create a view for “total hours for each project by each name”?

Welcome to the AppSheet community.

If I have correctly understood your structure and requirement,

please create a summary view such as a table view on the table Timesheet with following group by columns: Projects followed by Name

In the group aggregate setting please have SUM: Total Hours

An example setting below

Relevant help article

3 Likes