Skip to main content
The Add Column feature allows you to create custom fields directly in RetailGrid. You can add manual columns for notes or inputs, or calculated columns that automatically compute values using formulas. This makes RetailGrid flexible for pricing analysis, margin calculations, data enrichment, and operational workflows.
Image

1. How to add a column

Step 1: Open column menu

  • Click “Columns” in the top toolbar
  • Select “Add Column”

2. Select column type

You will see two options:
Image

Standard column

  • Create a column with a fixed data type
  • Used for:
    • Notes
    • Flags
    • Manual inputs
    • Tags

Formula column

  • Create a column calculated from other columns
  • Used for:
    • Margin
    • Revenue
    • Price differences
    • KPIs
👉 Choose based on whether you need manual input or calculated logic

3. Standard column

Image

3.1 Column name

  • Enter a clear name (e.g. Margin, Discount %, Notes)
  • Limit: 100 characters

3.2 Column type / display format

Choose how values should be interpreted:
TypeUse Case
TextNotes, labels
NumberQuantities, counts
CurrencyPrices, revenue
PercentageMargin, discount
DateEvents, timestamps
ToggleYes/No flags

3.3 Column color (optional)

  • Assign a color for quick visual grouping
  • Useful for:
    • Custom fields
    • KPI highlighting
    • Workflow states