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?
Utilizing IF functions to dynamically calculate amount
+17You 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?
+17Thanks 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.