I am trying to create an employee payrate board. Some employees get paid per hour, others get paid per appointment and the rate for appointments varies based on the appointment type. I am creating rate board that will mirror to another board that will calculate the rate of pay per employee.
what is the simplest way to go about this and what would the formulas look like?
I’d have an Employees board with a number column for the rate and then a status for the payment type ie by hour or by appointment.
Then a Project board that connects to the employee and mirrors in the pay rate and pay type.
Then a formula
Thank you Desiree! This is helpful! I will try this and let you know if it does the trick.
1 Like
Hey, thanks for the help here. it’s a drop more complex - I have three boards board 1 where the project is assigned with a automation to connect board and create an item in board 2. Then I have board 3 with the payrates for each employee. both board 1 and 3 are connected with mirrors 2 board two, but I would like to create an automation to run from board 3 to board two based on matching criteria that was created in board 2 (from board 1)? In laymen’s terms 
I would like a work around for the following automation (since it doesn’t seem to exist yet) When item (assignment) is created in board 2 and status (employee) is (Joe), connect Item (Joe) in board 3 to item (Joe’s assignment)in board 2. Any help with this would be appreciated!