Is there a way to insert a blank column or a column with a static value on each line in a report? | Community
Skip to main content
M
MichaelKe1
Level 2
December 2, 2022
Solved

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

  • December 2, 2022
  • 1 reply
  • 909 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by KristenS_WF

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

1 reply

KristenS_WF
KristenS_WFAccepted solution
Level 7
December 2, 2022

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
    M
    MichaelKe1Author
    Level 2
    December 2, 2022

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

      Terms & ConditionsAccessibility statement

      Loading footer...