Utilizing IF functions to dynamically calculate amount

Topic Labels: Formulas
654 3
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?

3 Replies 3
8 - Airtable Astronomer
8 - Airtable Astronomer

You could use a SWITCH formula.


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?

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.