Sign in to submit new ideas and vote
Get Started

Add a "Strict" Option to Auto Number Columns

Options

The situation is if a row is copied from one sheet to another, the Auto Number unique row ID coming from the source sheet will keep the same auto number on the target sheet. This results in duplicate Auto Numbers potentially, which causes duplicates in what should a column with unique values.

6
6 votes

Idea Submitted · Last Updated

Comments

  • Brian_Richardson
    Brian_Richardson Overachievers Alumni
    Options

    Yes! This is frustrating and confusing. Agree with Sam that we need an option though. Sometimes you need the original autonumber to copy, sometimes you want it to override. What would also help is being able to set more than one auto number column per sheet.

    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN