Sheet Name renaming options

I am trying to add a shorten sheet name in a report. I have read it is not possible to add Vlookup to a report so am hoping for a workaround. Can I add the sheet name column to each sheet used in the report and then add the vlook-up column to the sheet and then add that column to the report? Is there another way to do this?

Sheet Name - 01_MS 23/24 Subject Development Schedule want it to say MS Math Sch.

Thanks in advance


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!