GMH Data Model Workbook Module

Workbook.Module.txt

// --- Workbook Module ---
// Module containing named range definitions for the GMH Data Model Workbook.

/**
 * Get Sheet Names of Current Workbook
 */
Workbook.GetSheetNames = TRANSPOSE(SUBSTITUTE(GET.WORKBOOK(1), "[" & GET.WORKBOOK(16) & "]", ""));

/**
  * Define SheetNames
 */
Workbook.SheetNames = Workbook.GetSheetNames;

/** 
 * Get Sheet Names Filtering for a Pattern
 */
Workbook.GetSheetNamesByPattern = LAMBDA(pattern, 
  FILTER(Workbook.SheetNames, REGEXTEST(Workbook.SheetNames, pattern, 0))
);

/**
 * Define the Default Property Image URL
 */
Workbook.DefaultPropertyImageURL = "https://placehold.co/600x400.png";