Skip to main content

I’m looking for help writing a formula to show what pay a staff member has earned based on a variable.


I have hours worked (at 30 per hour for one role, and 25 for a different role), and trainings complete at 50 per session.


How do I write a formula that looks at the “role assigned select field” and calculates based on the correct rate of pay?


Thanks,

Hi @Ryan_Anderson1 - you can do something like this:


IF({Role Field} = 'Role 1', {Hours field} * 30, {Hours field * 25})


and then to include the trainings you can extend this with:


IF({Role Field} = 'Role 1', {Hours field} * 30, {Hours field * 25}) + {trainings complete field} * 50


For 2 roles, an IF statement is fine. If you end up with more than this, you can move to SWITCH statement, which is often easier than multiple nested IFs

Hi @Ryan_Anderson1 - you can do something like this:


IF({Role Field} = 'Role 1', {Hours field} * 30, {Hours field * 25})


and then to include the trainings you can extend this with:


IF({Role Field} = 'Role 1', {Hours field} * 30, {Hours field * 25}) + {trainings complete field} * 50


For 2 roles, an IF statement is fine. If you end up with more than this, you can move to SWITCH statement, which is often easier than multiple nested IFs


Thank you! I’ll start there and see if I have any issues, thank you!

Thank you! I’ll start there and see if I have any issues, thank you!



This isn’t correct - should be:


{Hours field} * 25

Reply


Terms & Conditions