Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Numbers out of sync

Sharon Middleton

Sharon Middleton ✭

09/19/17 edited 12/09/19 in Archived 2017 Posts

Does any one know why sometimes the automatic numbering system becomes out of sync as shown in the attached picture?

Thanks in advance

Sharon

0 ·

Comments

mclarke ✭

09/19/17

I have found this happens if you are auto numbering and delete a row. It 'remembers' that the number was already used.

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

How do I get a cell to display the value of the last cell in a column excluding one of the values?
Hi All, I have a column in a project plan with a droplist of certain values. I want to display the value of the last cell in the column that has any value except Not Started. Would someone please provide a suggestion?
Is there a way to have a form update existing information?
We are conducting an audit of our I-9s. In order to do so, we have pulled an active list of all of our employees (EEs). These EE names are already on the sheet. In order to effectively complete the audit, there are specific things we need to check for based on the expiration date of the I-9 document that we have on file.…
Pulling info from Reference Sheet based on Date
Hello, I am trying to pull the information I need based on a date on the referenced sheet. Without this criteria the formula works great. this one criteria is not working. I created a helper column on each sheet. on the reference sheet is a formula to calculate the month number for that row, and then on main sheet is a…