Weekly/Monthly In and Out Report
I have created a system to track inventory for a large warehouse for my company. We receive and ship out a lot of equipment daily.
I am looking to create a weekly and monthly report to give to management to show the amount of Square Footage that has been received and the amount that is shipped out.
Each company we store equipment for has their own sheet with all the columns they would need, but for the purpose of this question, we have columns labeled, "Status (To detail checked-in or checked-out") "Check-In Date" Check-Out Date" and "Square Footage".
When an item is received it is Checked-In, when sent out it is Checked-out. As soon as it is checked in, the equipment is measured for square footage. It is very normal for equipment to be stored for months at a time.
I have decent knowledge of Smartsheet functions, and basic formula knowledge.
Can someone please assist me with a formula that will track the amount of square footage that is "Checked-In" weekly and then a formula for the same thing monthly. And then Formulas for the same things "Checked-Out".
Screenshot Examples of my sheets below.
Answers
-
You would use a standard SUMIFS.
=SUMIFS([SQ FT]:[SQ FT], Status:Status, @cell = "Checked-In", [Date Column]:[Date Column], @cell>= TODAY(-7))
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!