This content has been marked as final. Show 2 replies
I have a xls sheet when 4 weeks e.g
Week for drafting
Week for review
Week for correction
Week for approval
Can I create a week field and use the same week field to search in all of the 4 weeks in the xls?
Example if I enter week 33 then my table list would list all entries that matches week 33 for either drafting, reviewing, correction or approval?
I tried to associate all the weeks with e.g. WeekNumber but gets an error
Any good ideas?