Build stable, high-performance dashboards using REPT formulas and UNICHAR symbols instead of conditional formatting.
The INDIRECT function has a rep for being a "nightmare," but for building reactive dashboards, it’s irreplaceable. Here is why I still use it.