> For the complete documentation index, see [llms.txt](https://docs.mashmatrix.com/mashmatrix-sheet/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.mashmatrix.com/mashmatrix-sheet/functions_advanced/time_series_matrix_transformation/limitations.md).

# Limitations

The time-series matrix transformation currently has the following limitations.

* Sorting and filtering cannot be applied for the child column of the matrix column.
* The option setting "Recalculate Formula on Record Update" is not currently available for the formula field child column of the matrix column.
* Currently only one type of object can be displayed inside one matrix column.
* For records to which time-series matrix transformation is applied, the time-series value must always be set to the first date value in that series. For example, when the display interval of the time-series matrix is set to "Monthly", records displayed in the "April 2024" series must have a date field value of "2024-04-01".
* If there is more than one record in the related list that matches a certain time series value, the first record found by the Mashmatrix Sheet is selected and used. Any priority or filter condition cannot be specified currently.
* If you clear the value displayed in the matrix column cell, a blank value is written to that field, not deleting related records automatically. Therefore, if a time-series matrix transformation is performed on a related list that includes required fields, errors for required field may occur when values ​​are cleared to blank and saved.