auto-numbering Created (Date) grayed out

I am trying to have my sheet keep track of new entries created using my form. I found that I could use Auto-Numbering and select Created (Date), by looking through the forums here. However, when I try to change the properties of my form, the Create (Date) option is grayed out. Can someone explain what might be going on?

Find more posts tagged with

Forms

Manufacturing

Sheets

Comments

Paul Newcome

If it is grayed out, that means it is already being used on the sheet.

Shawn Berry

Paul - Thank you! It appears that one of the other admin's created a row for the same reason I had, but for their form (and had it all the way over to the far right of the sheet). I just used their column for my purposes, and got what I needed.

Paul Newcome

Excellent! Happy to help.

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…