How to change the title of a sheet in the report calendar view?

I have a report set to calendar view with numerous sheets feeding it and due dates tied to them. The title for the bubble that shows up on the calendar view defaults to the name of the sheet. I want to be able to change the title to a cell within the sheet, is this possible?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!