Sumif and Approval between 2 sheets

Options

Hi Everyone, Formulas are for sure not my greatest skillset :) looking for some advice on the formula for a calculation only if Approval for the request has been approved.
It's a simple time bank for overtime where the Supervisor /Manager can see if the person is in the plus/minus with overtime.

2 sheets
Time Bank Employee Information
=SUMIF({SLP Time Bank Team Member}, [Employee Name]1, {TB hours in the minus1})
=SUMIF({SLP Time Bank Team Member}, [Employee Name]1, {TB hours in the plus1})
Both formulas take added/removed hours from the request sheet and give the total , but right now it will add for both approved and declined

Time Bank Requests


Answers

  • Mark.poole
    Mark.poole ✭✭✭✭✭
    edited 05/06/24
    Options

    Change your Formulas to =SUMIFS()

    What this does is give you the ability to use multiple criteria. Since I am unsure

    ex.

    =Sumifs({TB hours in the plus1},{SLP Time Bank Team Member}, [Employee Name]1,{Approval},"Approved")

    =Sumifs({TB hours in the minus1},{SLP Time Bank Team Member}, [Employee Name]1,{Approval},"Approved")

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!