# SETBLANKLABEL

SETBLANKLABEL can be used to replace blank row or column categories with custom text.

### Syntax

```javascript
SETBLANKLABEL.<ROW/COLUMN>(VALUE)
```

### Arguments

VALUE - Pass the custom value to use instead of blank categories.

### Example

```
SETBLANKLABEL.ROW('row_label')
SETBLANKLABEL.COLUMN('col_label')
```

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FtcDdjNaDFuf4gmshZ2nZ%2Fimage.png?alt=media&#x26;token=2c2c6544-0f90-4e58-a692-17364c73ccbc" alt=""><figcaption><p>SETBLANKLABEL function used in a variable</p></figcaption></figure>

Notice how the blank row and column categories are replaced with the custom text "DESC". The buttons use the SETBLANKLABEL script internally.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FOAjorKEdu13uBisFj2mm%2FUntitled%20Project.gif?alt=media&#x26;token=79ec6e32-93d1-48e9-98e5-ac3f8f7a9358" alt=""><figcaption><p>SETBLANKLABEL function in action</p></figcaption></figure>
