Can columns with different names be merged in a report?

edited 04/04/23 in Formulas and Functions

I am trying to create a report to consolidate task lists that are managed by other people. One person may have used "start" and another used "start date" for the same purposed.

Is there a way to merge those into a single column in a report, short of forcing everyone to use the same column names? I do have the option of having them add a column, but renaming columns would be much messier.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!