Assigning Overflow Credits
I am trying to automate educational credits. All users need a total of 8 hours of education. They HAVE to do 4 hours of neurotrauma hours. The remaining 4 hours can be general trauma or neurotrauma.
Person 1: Completes 4 neurotrauma hours and 4 general trauma hours. Complete
Person 2: Completes 6 neurotrauma hours and 2 general trauma hours. Complete
Person 3: Completes 8 neurotrauma hours and 0 general trauma hours. Complete
Person 4: Completes 2 neurotrauma hours and 6 general trauma hours. Incomplete. Needs 2 more NT hours
I'm thinking of any neurotrauma hours over 4 to be "overflow" to general trauma.
Any recommendations? Thanks.
Best Answer
-
Lets try a different approach
If Neuro is greater than or equal to 4 and grand total is greater than or equal to 8, then check the complete box?
=IF(AND([Neuro Trauma: Completed]@row>= 4, [Neuro Trauma: Completed]@row + [General Trauma: Completed]@row>= 8), 1)
Answers
-
How are the cells in your screenshot currently being populated?
-
Staff submits requests for approval of credits. The awarded totals populate in an employee reference sheet pulled from the request sheet.
=SUMIF({Email}, [Email Address]1, {Neuro Trauma Total})
=SUMIF({Email}, [Email Address]1, {General Trauma Total})
-
Lets try a different approach
If Neuro is greater than or equal to 4 and grand total is greater than or equal to 8, then check the complete box?
=IF(AND([Neuro Trauma: Completed]@row>= 4, [Neuro Trauma: Completed]@row + [General Trauma: Completed]@row>= 8), 1)
-
Thank you, that worked perfectly.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!