Hi! All Designer:
I've done some studies on existing posts but I can't find the answer. So here I am again.
I use NL("Sheet") function in cell A2 like this:
=NL("Sheets","Date","Period Start","Period Type","Month","Period Start",DateFilter)
And have another cell A3 reference to this cell A2 in order to create a date range:
=NP("DateFilter",$A$2,NL("First","Date","Period End","Period Type","Month","Period Start",$A$2))
Then the sheet name would become 01012012, 02012012, … which is not that pretty regarding to month period type.
I would like the sheet name to be "JAN", "FEB", …etc.
I try to use =Text(NF(""Period Start""),"MMM") in NL("Sheet") function. It works for changing the sheet name but the problem is the cell A3.
The Cell A3 won't work because 4Cell A2 has become "Jan", "Feb".. which is not a Date format.
How can I change the sheet name and let other cell be able to reference this cell A2 as well?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
Hmmm, that's a hard problem. I'm afraid the only way to do what you want would be replicating JAN, FEB, etc. as sheets and creating a range of hidden cells with the corresponding dates and doing a HLOOKUP to get the date corresponding to the abbreviation for filtering. It's a little brute force, but I'm not sure a more elegant solution exists. Does that make sense?
Regards,
Hughes
Please sign in to leave a comment.