Is there a way to insert a blank column or a column with a static value on each line in a report?

[MichaelKe1]

Is it possible to insert blank columns or columns with a static value (the same value for each line in the report) into a project report in Workfront? My situation is that I have a load spreadsheet template that is used to bulk load items into one of our ordering systems - the column order and number of columns must remain the same as the template. Some of these columns to not pertain to my department and would remain blank, some of the columns will have the same value in each line (department code for example). I would like to be able to set up a report in Workfront that can be pulled that would match the load template so that no additional work would need to be done in Excel before submitting the spreadsheet to be loaded. Is this possible?

[KristenS_WF · Accepted solution]

Yes, you should be able to use text mode to create blank and static-value columns:

displayname=Blank Column
textmode=true
valueexpression=""
valueformat=HTML

displayname=Static Column
textmode=true
valueexpression="Static Value"
valueformat=HTML

[MichaelKe1]

Thank you so much! I very much appreciate you taking the time to explain this.