Formula columns display information from related tables through 2-N relationships

In my example, I have a simple structure: Project -> Project Task -> Timesheet (Project and Timesheet do not have a direct relationship).

?

The Project contains information about the "Project Type," which is an option set.

?

?

If I want to display this attribute on Timesheets records, I can create Formula Columns on the Timesheet table and access the attribute through the Project Task table.

?

'Project Task'.Project.'Project Type'

?

?

As a result, even without a direct relationship, I can display the value from the Project on Timesheets records, where users can use it, for example, for filtering.