Skip to main content

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?

You could use a SWITCH formula.


Ex.


SWITCH({Role Selection},
"Main photo", 50,
"Main video", 75,
"2nd shooter", 35

You could use a SWITCH formula.


Ex.


SWITCH({Role Selection},
"Main photo", 50,
"Main video", 75,
"2nd shooter", 35

Thanks Zack!


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?


Thanks Zack!


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.


Reply