Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Utilizing IF functions to dynamically calculate amount

Topic Labels: Formulas
149 3
Showing results for 
Search instead for 
Did you mean: 

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

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.