Post

2 followers Follow
0
Avatar

Relations & Vlookup

Hi, I can't figure out how to work with relations & lookup values in other tables.

The case:

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.

 

Some screenshots:

Projects:

Hour rates per freelancer per project:

Timeshets

 

 

Olivier De Lamper

Please sign in to leave a comment.

2 comments

0
Avatar

Hi Olivier,

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?

Rainer

Rainer Grabowski 0 votes
0
Avatar

@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 :-)

 

Olivier De Lamper 0 votes