Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.
SOLVED

is there any way to set or pass in a variable that will persist through text mode columns in a report?

Avatar

Level 2

I would love to be able to set a variable value once in text mode in the first column of a report and then repeatedly use that variable throughout the subsequent columns. Is there any way to do this?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@VynetaRy - if you are using a value expression in your text mode the short answer is no, this is not possible. The results of your value expression aren't stored anywhere in the database of Workfront and it only exists in your column in your report. Kind of like using a basic calculator without the memory buttons. 

 

The workaround is to create calculated fields that live on your custom forms tied to the objects you are reporting on that way the data is "stored" somewhere for reference. 




View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

@VynetaRy - if you are using a value expression in your text mode the short answer is no, this is not possible. The results of your value expression aren't stored anywhere in the database of Workfront and it only exists in your column in your report. Kind of like using a basic calculator without the memory buttons. 

 

The workaround is to create calculated fields that live on your custom forms tied to the objects you are reporting on that way the data is "stored" somewhere for reference.