How do I set up a formula tool in Alteryx to reference new columns when I run my workflow

Question

Hello,

I have the below workflow set up to pull data from a live share point file and filter through the latest four weeks to create a monthly report. The monthly report is then sent out to a subset of recipients. The issue I'm having is that every time I run the file for the reporting month, the formula tool is referencing the wrong columns as they are updated every week. How can I get my formula to always reference the correct columns to produce the monthly total I need? Below is a screenshot of the workflow

prpatel · Answer

use actual names where possible to avoid the issue that you are seeing.

Robin_McIntosh · Answer

So your formula is referencing fields labled 28,29,30,31. If your input report has different columns or different order of columns, you will need to get them in the correct order so that 28-31 are the columns you want to use before the formula or use actual names for the field labels.