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
-
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
-
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
-
Thank you again @Jon Mark H @Jon Mark H! that sneaky @row again, i cant wait to be more comfortable and savvy with formulas!
-
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!
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!