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.
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