Calculating Awarded Estimates
I have a running list of estimates we submit. when we are awarded the project that column gets checked. im looking for a way to scan the entire column and report back the percentage of estimates we have been awarded to the total number we have quoted to date.
I would also like then to check how many awarded projects have been repeat job as opposed to new jobs. There is a column checked if the estimate is a repeat job.
Help Article Resources
Check out the Formula Handbook template!