Productivity Formula

ldavenportHAP

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!

Jon Mark H

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

Jon Mark H

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

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

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

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!