Allow Field Mapping

MariaCurtis

Hi! It would be great if we could map similar fields from one sheet to another in order to bring them together in a report or consolidated sheet, rather than having to rename columns.

Use case: We want to link up a sheet that our IT PMO uses and our HR PMO uses. Both have similar fields with different names. We don't want to change names in either sheet because they're both using automation, formulas, etc. Field mapping could help us keep our current sheets as they are, but also created a consolidated version where the "like" fields align.