The GTPATNUM function returns the record number of the ‘reference’ cell in a pattern. If no argument is passed, the cell containing the formula is used.
- This function returns #N/A in Design.
- Combined with conditional formatting, this function can be used to perform band-coloring in a pattern.
In the previous example, we put the following conditional formatting on the basic pattern:
This is how it looks after a Design Import. Note the conditionnal formatting formula.
This does not change the appearance in Design (because GTPATNUM returns #N/A), but in GTAnswer, we have the following result:
Like all GT functions (except GTMS.), this function only has its value stored in the Excel workbook exported from the questionnaire. For more details, see XLSX Export.