Need help with a formula: Tracking state changes during a time period
At my company we ship hundreds of expensive of items to lots of destinations. In netsuite we track the status of these items with a simple list value, (e.g. “In fabrication”, “Ready to pickup”, “Shipped”)
What I’m trying to do is run a tally of all the items that were marked “Shipped” in the past 7 days from list customlist369.
Can someone please help me hack out the formula such that I can run a saved search and return only items that shipped last week?
FYI this is using the “Projects” resource.
Thanks a lot!
Hi, where do you list the items and set the status for each? Is the customlist369 shown on a custom body field or column?
Set the criteria to be “System Notes : New Value” equals “Shipped” & “System Notes : Date” on or after “a week ago”, plus the main line as you want it defined (related to my second question). Under Results, group by Status, group by Item, count by Line ID (or internal ID of the transaction).