I have an input sheet that will update weekly based on the date. This week is 'Available 18 Jun 2018' and next week will be 'Available 25 Jun 2018' and so on.
So to avoid a conflict with the header renaming every week when I repull the sheet and run - I used a select tool to rename the field 'Week 1'. I have a filter set up that has the expression '[Week 1] >= 20 AND [Local grade/Job level] != "Director"' (it did say "[Available 18 Jun 2018] >= 20 AND [Local grade/Job level] != "Director"' originally).
But when I output the data I don't want it to say Week 1 - I want it to be the actual week description (like Available 18 Jun 2018). I can't see a way to reference back to the original, so maybe I need to use a more generic name in the filter? What do you think?
TYIA for the help.
Solved! Go to Solution.
Hi @shpruitt, is this a macro or a workflow?
And could you share a screenshot of your workflow configuration? Or even better share the workflow?
Ben
I downloaded your workflow and it gave me a message it was newer than mine - then said I no longer had a product key and locked mine down. So I can't see/run anything or send you the workflow. I tried a screenshot too and it won't work. I'm going to try uninstalling and reinstalling.
Is there a way to not rename the header and use a filter that just references that column? The column will be the same every week.
11.7 x64
Thanks so much Ben!! This is a really cool feature. My mind continues to be stretched daily.