Metadata to Summary Sheet

SCC

I am having a problem where my Summary Sheet is trying to pull data from the wrong column in my Metadata sheet. The data in Metadata is in my date column, yet the link is taking from the text column. Can anyone share a way to change the link.

Paul Newcome

There is no way. The summary sheet is always populated by the column immediately to the right of the Primary Column in your metadata sheet. You will need to use a formula to bring the date over to the Text column and then convert it back into a date on the Summary Sheet.