I need help with a formula please.
Answers
-
The community is here to help!
Let us know what you're struggling with, and we'll do our best!
Break it down, and provide screenshots to help paint the picture.
-
Thanks. I am looking to create a sheet to track attendance points.
I would use a drop down menu with various options. Each option will have an assigned point value per associate. So each associate will be assigned a row, and their Supervisor will choose the correct drop down option daily. I would also like to have a column that keeps a sum of points, so that we can assign any disciplinary action according to our policies.
First question: How do I assign a point value to each of the drop down options.
2nd: How do I keep track of the accumulated points per associate.Example of the layout.
Thanks for the help.
-
=IF([THU]@row = "Tardy", 0.5, IF([THU]@row = "NCNS", 6, IF([THU]@row = "AWOL", 1,)))
This has been my attempt to assign a point value to a couple of our dropdown options. I am getting an error message.
-
=IF([THU]@row = "Tardy", 0.5, IF([THU]@row = "NCNS", 6, IF([THU]@row = "AWOL", 1, "Otherwise" )))
Just fixing your formula, seems like you have an extra comma or missing 'IF FALSE' arguement.
2nd: How do I keep track of the accumulated points per associate.
You can use SUM function. But your formula might be longer than expected.
With limited view of your sheets, and without adding helper column I would multiply the count each status with its weight and then add them. Something like:
ATTENDANCE POINTS =SUM( COUNTIF(THU@ROW:THU(9)@ROW, "Tardy") * .5, COUNTIF(THU@ROW:THU(9)@ROW, "NCNS") * 6, COUNTIF(THU@ROW:THU(9)@ROW, "AWOL") * 1)
...
-
Thank you so much. This worked perfectly!!!! @heyjay
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!