Assign the module name for the line item

qsong1

Hi Community

 

I have a module with the following structure:

	Module Name
---INPUT---
Transportation fee	INPUT
Meal fee	INPUT
--- CALCULATION ---
Trip expenses	CALCULATION

 

What I want to create a column named 'Module Name' is to display the module name; In this case, it is input and calculation (input and calculation are headlines). So basically all line items located after the headline X before the headline Y will be assigned the module name X.

 

Is there a way to deal with it without doing anything manually (for example, creating list to populate the module names?

 

Thank you

 

Best, Qianru 

qsong1

@Amaya Thank you so much. That works pretty well.

 

Best, Qianru