How to set a formula to repeat when adding new entries at the top of the page?

I have a sheet that captures employee's leave requests to show up at the top (most recent first)of the "grid" and on the "calendar" and I need it to occur with every entry. How do I set it to ensure that every entry will be displayed and automatically filled with the formula fx=[employee name]1. The formula pulls the information (employee name) from the second column to the primary column. However, after so many new entries the formula doesn't repeat and leaves blanks on the grid and the calendar.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!