Calculating Awarded Estimates

edited 12/09/19 in Formulas and Functions

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!