# SheetRocks Recipes

This guide demonstrates practical patterns and workflows that make SheetRocks uniquely powerful for enterprise use cases.

## Lambda Functions & COL Syntax

SheetRocks supports lambda-style operations using the `COL` keyword, enabling powerful data filtering and transformation without complex formulas.

### Basic COL Reference

The `COL` keyword references entire columns:

```
COL[A]         # References all values in column A (by letter)
COL[1]         # References all values in column 1 (by number, 1-indexed)
COL[D]         # References all values in column D
```

**Note:** COL only supports column letters (A, B, C, etc.) or numeric indices (1, 2, 3, etc.). Column names/headers are not supported.

### FILTER with Lambda

Filter rows based on conditions:

```
=FILTER(A:F, COL[D] = "Active")
```

This filters the range A:F to only show rows where column D equals "Active".

### SUMIF with COL Syntax

Conditional aggregation using COL references:

```
=SUMIF(E:E, COL[D] = "Paid")
```

Sums all values in column E where column D equals "Paid".

### MAP Function

Apply transformations to ranges:

```
=MAP(A1:A10, COL[1] * 1.1)    # Increase all values by 10%
=MAP(A1:A10, COL[1] * 2)      # Double all values
=MAP(A1:A10, CELL^2)          # Square each value
```

## Tags and Smart Dropdowns

Tags provide an intuitive way to select and reference Salesforce records within SheetRocks. The TAGS function takes a table with headers and converts it to a JSON array. Shallow JSON objects are automatically rendered as interactive tag pills.

### Basic Tags Example

Create tags from a simple table:

```
=TAGS(A1:B4)
```
Where cells A1:B4 contain:

```
label      | color
Option 1   | blue
Option 2   | green
Option 3   | red
```

This creates JSON objects `[{