I have a payroll base that my workers fill out a form and then they submit a role (Main photo, Main video, 2nd shooter) I have a set rate for each role in each wedding that is literally different for each one. How can I structure a IF statement to dynamically pull the right amount to calculate how much they are owed from the job?
I don’t think that’s what I’m looking for. I don’t have a set amount that will work as each project has a different rate. Can I pull in that date via a cell in the project instead of a static amount?
Not sure how you currently have your base setup. But you could use a linked record field with a lookup field to pull in your rates for each specific project.
If you share your base (make a copy of it and put ‘dummy’ data in it) it will help someone here provide a better suggestion.
