How can we help?

Search for answers or browse our knowledge base

< All Topics

GTPATNUM function




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:

Excel export

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.

Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Previous XLSX Export
Next Reading structures of an Excel workbook
Table of Contents