> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# What's new in Sigma

> Sigma release notes for Oct 6, 2024: Excel function alias support, custom number format specifiers, and more.

## Functions

### Excel function alias support

When you enter an Excel function alias in the formula bar, the autocomplete dropdown suggests the corresponding Sigma function.

For example, when you enter `Average` (an Excel function alias), the dropdown suggests the **Avg** function.

## Workbook elements

### Custom number format specifiers

Custom number formatting supports the following specifiers to define precision and prefixes:

|    | Specifier function                                                     | Example string and output |
| :- | :--------------------------------------------------------------------- | :------------------------ |
| s  | Format a fixed number of *significant figures with an informal prefix* | .2s → 120B                |
| S  | Format a fixed number of *decimal places with an informal prefix*      | .2S → 123.46B             |
| g  | Format a fixed number of *significant figures with an SI prefix*       | .2g → 120G                |
| G  | Format a fixed number of *decimal places with an SI prefix*            | .2G → 123.46G             |

Informal prefixes include k (thousand), M (million), B (billion), T (trillion), etc. SI prefixes include k (kilo), M (mega), G (giga), T (tera), etc. The example demonstrates the output of the custom format string when applied to the value 123,455,000,000.

## Bug fixes

* In the workbook header, the version menu now displays the **Tag this version** and **Tag this published version** options as disabled (grayed out) when no tags are available.
* Users can now consistently use the **Set favorite** setting in workbooks.
* Workbooks no longer require a browser refresh to reflect deleted tags.