Leverage real-time formulas and filters for complete parcel visibility, directly from your dashboard.
Manually checking dozens of parcel statuses is time-consuming. The Sugargoo SpreadsheetSugargoo Dashboard
Core Benefits of the Automated Spreadsheet
- Automatic Updates:
- Real-Time Visibility:
- Custom Filtering & Sorting:
- Data-Driven Decisions:
- Real-Time Visibility:
Getting Started: Accessing and Structuring Your Data
- Log into your Sugargoo account"My Parcels""Warehouse"
- Locate and open the Spreadsheet viewData Export
- Your data is now live. The spreadsheet acts as a dynamic mirror of your dashboard.
- Locate and open the Spreadsheet viewData Export
Key Formulas for Enhanced Tracking
Use these formulas in adjacent columns to analyze your data. (Assumes data starts in Row 2).
| Purpose | Example Formula | How It Works |
|---|---|---|
| Flag Delayed Shipments | =IF(AND(D2="Shipped", TODAY()-E2>7), "Check Delay", "OK") |
Checks if status is "Shipped" but the "Shipped Date" (cell E2) is more than 7 days ago, prompting a review. |
| Calculate Cost Per Gram | =IF(G2>0, F2/G2, "N/A") |
Divides Shipping CostWeight (grams) |
| Consolidate Status Summary | =COUNTA(UNIQUE(C2:C100)) |
Counts the number of unique order statuses present in your list (e.g., Purchased, Shipped, Delivered). |
Using Filters for Real-Time Order Visibility
- Select your data range and enable the Filter
- Use the dropdown arrow in the Status
- Filter the Date
- Combine filters! Show only "In Warehouse" parcels that are over 2000 grams to plan your next shipment.
- Save these filtered views for quick access during your weekly review.
- Use the dropdown arrow in the Status
Pro Tips for Power Users
- Link to Tracking:=HYPERLINK("https://track17.com/en/track?nums="&B2, "Track")
- Highlight Rows:Conditional Formatting
- Create a Dashboard Summary:SUMIFCOUNTIF
- Highlight Rows:Conditional Formatting
Conclusion
By mastering the Sugargoo Spreadsheet's automation, you transform raw parcel data into actionable intelligence. No more manual refreshing or guesswork. Implementing a few strategic formulasfiltersreal-time order visibility, allowing you to manage your shipments proactively and efficiently. Start automating your tracking today and spend less time searching and more time optimizing.