I assume the fields "Project" in Timesheets and Hour rates are both relationship fields to the Project app - right?
Are multiple freelancers working for the same project or always only one freelancer?
Relations & Vlookup
Hi, I can't figure out how to work with relations & lookup values in other tables.
I have different freelancers working on different projects. Their hourly rate is different per project.
Freelancers fill in hours per projects, but not hourly rate.
Hourly rate per freelancer per project is maintained in another app;
In my Projects app I want a report on the total of all hours logged per project (that is easy), but also the total budget = per freelancer the total of hours worked * the hourly rate. I can't figure out how to do that. Thank you for your help.
Hour rates per freelancer per project:
Please sign in to leave a comment.
@Rainer: yes indeed: Timesheets & Hour rates are linked to "Project".
Multiple freelancers are indeed working on a same project.
I need some kind of VLookup throug all hours logged by Freelancers on a project * their hourly rate for that specific project. Apparently not that straightforward (or at least I can't figure it out :-)