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

Question about copying a sheet
I use Smartsheet to track my yearly activities. I have a sheet that is connected to this sheet for calculations that feeds into a dashboard. Hopefully that makes sense. My question is, I want to copy this entire thing and start new for 2025, however when I copy, the calculation sheet is still pulling from the 2024 sheet.…
Help with revision of Nest IF Statement for Symbols
Need a revised formula, which is in the Certification Complete column. This worked great. However I was just made aware of something. Okay, @dojones provided a perfect solution. However, as we are all aware, we are not always told about all the pieces of the puzzle. that solution was: =IF(AND(ISBLANK(Certify@row),…
Sum of only last child in cell range
Hi there I would like to count the values of only the last children in the column. Some cells have one indent, some more, so I would like to know the formula, to count only the last indent children. Below is an example what I would like to achieve. The result of the formula should be 350. Additionaly I would like to…