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))
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!