We have a rolling bonus for each of our sales representatives and appointment setters. In total there are 10 people eligible for this.
Currently, I have table created for each individual with the data to calculate their rolling bonus.
Columns includ...
I need to create a nested IF(AND statement for my commission sheets.
Logical Argument 1: If the Set By field has a value in it AND
Logical Argument 2: If the Month field is January, February, March or April
The result would be:
Calculate the formul...
Hello,
I am trying to create a table for our sales employees rolling bonus program. I have the main bones built, but I am struggling in one area.
I need a way to add values in a compound manner.
Example:
January they reach bonus and earn $500Februar...
Hello. I am struggling with how to transition my Google Documents over to an Airtable Database. I have a table I created with two sheets (1) Job Ledger (2) Commissions.
Currently, in Google Sheets, I have a master ledger account and 10 separate doc...
You make a completely valid point. I will need to revisit this with my sales team, as they were originally paying the 12.5% out of their commission, whereas now it should be 0.625% out of their commission.
