Is there a way to have a formula for the whole column?

Hi Smartsheet,

I am utilizing Smartsheet for employee information and have found a way to generate documents. I want to be able to title the document "Effective Date - Employee Name - Change Reason." I've looked up resources since the title of generating documents can only hold one column.

Other Smartsheet resources told me to create a column in my Smartsheet with a formula and then use that as the title. I was able to create what I need in one cell with the formula:

=[Effective Date]1 + " - " + [Employee Name]1 + " - " + [Change Reason]1.

Is there a way to have that formula be the standard for the whole column?

Thank you for your help. If you have any questions, let me know!

Thank you,

Christian Ong


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!