Change column display name based on row value

[orangeboy]

Hi All,

How do I change the column display name based on the row value?

Example: If A,B,C default column name is "QTY"

If X,Y,Z I need the display name to be "Prepped QTY"

Thanks in advance

[WillowMobileSys]

Every column definition has a Display section. In it you can specify an expression that is used as the column display label.  See image.

[Markus_Malessa · Accepted solution]

Select the appropriate column from your table, go down to Display and expand, in the 'Display name' try the following:

IF(IN([_THIS], {A,B,C}), "QTY", "Prepped QTY")

 Alternatively you can use IFS() and include a default at the end of the comparison like so:

IFS(IN([_THIS], {A,B,C}), "QTY", IN([_THIS], {X,Y,Z}), "Prepped QTY", TRUE, "Some other Label")