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.

Find more posts tagged with

Manufacturing

Formulas

Reports

Comments

Nic Larsen

I think this is what you are looking for for your first request.

=AVG(COUNTIF(Awarded:Awarded, =1) / (COUNTIF(Status:Status, ="Quoted")))

Mike Wilday

This will give you the count of all Awarded and Previously Quoted jobs.

=COUNTIFS(Awarded:Awarded, 1, [Previously Quoted?]:[Previously Quoted?]1)

Mike Wilday

Put on the brakes. There was an error there.

=COUNTIFS(Awarded:Awarded, 1, [Previously Quoted?]:[Previously Quoted?],1)

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Issue with automation process reporting a date in a special column
In the Smartsheet sheet “CRS RO Master” we have programmed an automation called “Track Changes in dates, confirmation and LHG code” [PICTURE 1] This one should report a date of a change in the columns “CRS GO LIVE DATE” and “PMS Go LIVE DATE” in the column “. CRS Check date changed”. [PICTURE 2] The update of the “Go live…