Productivity Formula

Hello, i am trying to add a formula to create a symbol depending if an employee is meeting their required productivity. The required productivity changes per position so the requirement would be populated in its own column


this seems so simple and yet i cant quite figure it out!

Best Answer

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭
    Answer ✓

    Hey!

    Looks like this should work for you:

    =IF([Accounts Per Day w TOOQL]@row < Level@row, "No", "Yes")


    You could extend the formula to include a check so it doesn't say "Yes" on blank rows, if you wanted to as well.

    Let me know if that fixes the problem, or if you need help with anything else!

    -Jon Mark

Answers

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭
    Answer ✓

    Hey!

    Looks like this should work for you:

    =IF([Accounts Per Day w TOOQL]@row < Level@row, "No", "Yes")


    You could extend the formula to include a check so it doesn't say "Yes" on blank rows, if you wanted to as well.

    Let me know if that fixes the problem, or if you need help with anything else!

    -Jon Mark

  • ldavenportHAP
    ldavenportHAP ✭✭✭✭

    Thank you again @Jon Mark H @Jon Mark H! that sneaky @row again, i cant wait to be more comfortable and savvy with formulas!

  • ldavenportHAP
    ldavenportHAP ✭✭✭✭

    Actually @Jon Mark H could you let me know how i would add it so that it doesnt say Yes on blank rows? i think it might make my doc look cleaner. Thank you!

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭

    Yes - no problem.

    This should work:

    =IF([Accounts Per Day w TOOQL]@row <>"", IF([Accounts Per Day w TOOQL]@row < Level@row, "No", "Yes"),"")

    This will check to see if the Accounts Per Day w TOOQL cell is blank (not equal to nothing) or not -

    If it IS blank it will show nothing, hence the "".

    If it is NOT blank - then it will run the other criteria check you had down previously.


    Keep on practicing and you'll be a pro with the formulas and quirks of Smartsheet in no time!

    Glad I could help!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!