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.
Comments
-
I think this is what you are looking for for your first request.
=AVG(COUNTIF(Awarded:Awarded, =1) / (COUNTIF(Status:Status, ="Quoted")))
-
This will give you the count of all Awarded and Previously Quoted jobs.
=COUNTIFS(Awarded:Awarded, 1, [Previously Quoted?]:[Previously Quoted?]1)
-
Put on the brakes. There was an error there.
=COUNTIFS(Awarded:Awarded, 1, [Previously Quoted?]:[Previously Quoted?],1)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!