I’m tracking leads in a sales pipeline. How can I calculate the conversion rate from leads to closed deals using Stackby formulas?
Hey,
You can use the COUNT() and COUNTA() functions to calculate the conversion rate. Create two separate columns to count the total number of leads and the total number of closed deals. Then, divide the number of closed deals by the total number of leads.
Example : COUNTA({Closed Deals}) / COUNT({Leads})