Changing header

Tid14

Hi, I am building a WF in which I have 3 headers namely

FY 2019

FY 2020

FY 2021

and I have to apply numeric formulas in these columns and then make it an app.

Here I want to use a logic where I can change these years Column to something static for applying the formula so when in next cycle the years will change to for eg:

FY 2020

FY 2021

FY 2022

we dont have to change anything in the WF and it picks from these headers only.

messi007

@Tid14,

Do you're columns FY 2019, FY 2020, FY 2021 are always in the same position ?

Id yes you can read the file without header 

In the formula you will use F4, F5, F6 instead of FY 2018...

Hoe this helps,

Regards