How can I add a "percent staffed" calculation?


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
    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!