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.

• 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.