Sumif and Approval between 2 sheets
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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!