#INVALID OPERATION when dividing

Joshua Peacock
Joshua Peacock ✭✭✭
edited 12/09/19 in Formulas and Functions

I'm trying to do a count of how many staff have uploaded a particular document. I have who has uploaded the document and how many staff in total, and I want to display that as a percentage on the sheet. Whenever I try to divide # of Staff Uploaded by Total Staff I get #INVALID OPERATION. I've tried it both in formula and just pluging in the numbers manually but it keeps happening. Here's what I was trying to use:

=([Staff Uploaded]10 / [Total Staff]1)

And then format the result as a percentage.

Is that correct?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!