Sign in to submit new ideas and vote
Get Started

Keep auto number as number, do not turn it into text when using Numerical Places.

When creating an auto-number column, if you choose anything different than Numerical Places being 0, it will detect the column as text.

Therefore, making calculations with the auto-number column behaves different depending on the properties used.

For example, the formula =[Row ID]@row + 1 shows different outcomes as the following:

If Numerical Places is 0, it will sum the value turning Row ID 1234 into 1235

If Numerical Places is 0000, it will add the 1 as text, turning Row ID 1234 into 12341

This mismatch on the behaviors also affects other features such as sorting or indexing and should not be considered expected when the same column name already has the word "number" on it.

6 votes

Idea Submitted · Last Updated