Auto-Number/System field Created (Date) changes back to "Date" field

Ausrine Balletta

I have an Auto-Number/System field called "Date Submitted" as Created (Date). This is used on the manual form (which we are phasing out) and also to capture any new rows that come in from Salesforce sync. For some crazy reason it keeps changing column properties to Date. In which case two things break:

1. Anything that syncs from Salesforce does not get this field populated.
2. My automation rule to move rows fails, because the Archive sheet is set up with Auto-Number/System field "Date Submitted" as Created (Date), and I get this error message: Rows can't be added to the destination sheet because a system column has the same name as column on the source sheet.

I have removed admin permissions from anyone on that sheet (+ workspace), as originally I though people were changing this on purpose, however I am not so sure about this and the users, that are logged as they changed the column properties, say they did not touch the column properties nor would know how to do it.

It seems to be somewhat connected to users changing Stage of the row picklist values. They also use card view and just drags and drops cards form one lane to another changing the Stage value.

Does anyone have any idea what is happening here? I just keep getting notifications that my workflow fails.

P.S. your "Ask a Question" tags add 4 of the same tag when clicked. O_o

Paul Newcome

Ok. If it is still happening while there are no other users that can change it and you aren't changing it either, I would suggest reaching out to Support.

Paul Newcome

I would suggest taking a look at the Activity Log to see what it says when the column is changed. If it says nothing about the column change, then you may need to reach out to support. I believe there was someone else having a similar problem here in the Community recently, but I can't seem to locate the thread.

@Genevieve P Just wanted to bring the "P.S." to your attention...

Ausrine Balletta

Thanks Paul, Activity Log does say that it was changed by a user. I have removed admin rights from them, and they swear they did not do it nor know how to change it, nor have any reason what so ever to change it. Some sort of bug is going on here.

Paul Newcome

Has it happened since? I do remember seeing a similar bug recently, but I can't remember what the outcome of it was. I am pretty sure it was a bug though in that case.

Ausrine Balletta

It has been happening multiple times every single day since this Monday morning (3/2) when users started using it after I added a sync to Salesforce to an already existing Smartsheet (previously rows were added by submitting a form). Form used this date field too, but I have removed it from there now since all should be tracked automatically.

Paul Newcome

Ok. If it is still happening while there are no other users that can change it and you aren't changing it either, I would suggest reaching out to Support.