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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    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)

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!