Basically I have a process in which i perform vlookup between 2 files and fills values in a different column.
Columns are named Jan forecast values, Feb forecast value, Mar forecast values and so on... Until Dec forecast values.
When I am running report in January for January input files, I want the lookup values to be filled in the column header Jan forecast values, when done in February, with February input files the corresponding values must get populated in Feb forecast values etc...
so what you can do is add a dynamic filter tool and create a dynamic formula selecting the current month.
Contains([Name],tostring(DateTimeFormat((DateTimeToday()),"%b"))
something like this.
@Isha_Gupta Dynamic select tool would be useful for your use case
User | Count |
---|---|
106 | |
82 | |
70 | |
54 | |
40 |