How can I add a "percent staffed" calculation?

Andrew Ryback

Hi everyone,

I have a sheet listing contractors that have been hired for specific projects. Is there an easy way to add a "percent staffed" calculation based on the positions listed for the project, and names of contractors that have been confirmed?

Thank you.

Emory

If you are trying to count multiple contacts in a single cell, something like this may be useful.

You can use this formula to count contractors, then divide by the number of positions. Then if you set that column to a percentage, you should be all set.

=IF([Column8]@row <> "", LEN([Column8]@row) - LEN(SUBSTITUTE([Column8]@row, ",", "")) + 1, 0)

Never mind the "Column8". I was using a test sheet to try this formula out.

Also, the "IF" function is just incase the cell is blank.