Use dynamic shapes and images in websheets

Customize your websheets! In TM1® Web, you can dynamically insert shapes and images anywhere in your websheet where you’d like the image to change when the value of a cell changes. You can dynamically insert logos, employee pictures, flags, product images, and more.

A dynamic image can be created by assigning a named range that contains an INDIRECT or INDEX-based formula to an image object. The formula resolves to a cell reference, and if an image is anchored to that cell, the dynamic shape reflects that image object's content.

To support this feature, TM1 Web persists the assigned formula, and when it recalculates, TM1 Web evaluates the named range formula to a cell reference. Using this cell reference, TM1 Web can then update the image object's file name to match the referenced image.