How to display a cell with a countifs formula as a percent?

I have one cell that has a COUNTIFS formula to count the total number of projects and another cell with a COUNTIFS formula to count the number of projects that will be complete by October 27th. I don't actually want a count of projects complete by 10/27 I need a percent. Can I divide the count in cell 2 / count in cell 1? Or do I have to do that in a third cell?


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!