I want to report the values of mixed data types in a single column
I have many many sheets where column names are the same but data types are different (ex: some "Assigned to" columns are text/numbers and some are contact list, some "Project Name" columns are text/numbers, and some are dropdown list.) The choices in value type are driven by the many teams specific needs.
This creates multiple columns of the same name when configuring reports. How can I display the data VALUES in a single column in my report regardless of data type? (ex" a single "Assigned to" column will display as a text name or a @<contact_name>, a single "Project Name" column will display as the value enterer or selected by the user.
It is the value that is important in my reports, not the data type. :-)