Why is Auto-Number greyed out?

Tim Sheehan

I understand auto-number can't be selected for a primary column. However, even on other columns when I select Auto-Number/System as the column type, the first sub-type, Auto-number, is greyed out. It doesn't matter if i create a new column at end of the sheet, it is still greyed out. I can't find any explanation for this. Any ideas? On other sheets, it works. I am an owner/admin for the sheets in question.

Andrée Starå

Hi @Tim Sheehan

Make sure that there isn’t another auto-number column already.

Did that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Tim Sheehan

Yes- I think that helps. I didn't see any mention anywhere else that there can be only one per sheet. That is too bad! thanks though.

Andrée Starå

@Tim Sheehan

Excellent!

You're more than welcome!

Depending on your use-case, there might be a workaround to create something similar in multiple columns as needed.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

glitchwizard

So how do we get multiple auto number columns?