Auto Update Fields

I have started creating a custom timesheet app. As we don’t require some of the features in the templates. What I am trying to do is when a new record is created create a cell value of say “Timesheet#: 1” for display purposes. The 1 being the autoincrement value. I have tried the text formula, but it doesn’t update when the record is created.

*** EDIT *** Figured it out. Created a number field first to duplicate the auto field with record rules, then created the field value i was looking for with a text formula that updates after the number field is created.