Within each Media Type you can control what columns should be presented.
Create, add or delete columns.
Create a Column – In order to create a new column click Settings then
Select the desired Media type to edit in the drop-down menu.
Within the media type settings click at located at upper right corner.
Choose whether it should be a header or an entry field:
- Entry Field is a column visible in the sheet view where you enter data for the plan (generally the most common field you will use).
- Header Field is a visible field at the top of each media type; common usage is, for example, notes, comments, and currency exchange information.
Enter a name and choose the format for your column - Text, Date, Number or Calculation.
Text – Free text field
Date – Date field
Number – General number or percentage. Choose whether to have a total, average or none at the top of the column. Choose the number of decimal places.
Calculation – Create a calculation with already existing number columns (i.e. in order to create a calculation make sure you have all fields that you are using for the calculation within the same media type). Enter the calculation by tagging @name of field. Use general calculation signs (/,-,+,*). Choose the number of decimal places.
Note, a calculation column can only be based on number fields.
You can choose to have a description for each created column, this will be visible if you scroll over the field in the sheet view, this is not obligatory.