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
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!