I have two tables on air-table.
One for Staff, another for Leads.
Staff: grouped under type: organic sales, paid sales, and coaches.
Fields: Type, Total Revenue, Total Leads.
- How can I change the formula for each staff type?
- How can I calculate the total revenue biweekly? and reset it every biweekly period? The amount to be paid to the contractors is based on the revenue brought in in each of the 26 periods of the year.