Bug: Text/Number Field changes itself to Date field for column.

This has been happening several times a day where a column I have designated for text input changes itself to a date field. I have data being input by form users to rows. They go to use the form and are presented with a date field where they are supposed to be inputing several sentences of text for their daily report. I go in and manually change the field type back to Text/Number so they can use the form (several times per day)

I've contacted SmartSheet tech support.

Find more posts tagged with

Forms

Construction

Project Management

Comments

Alejandra

Hello,

Thank you for submitting a support ticket regarding this behavior. Our support team has confirmed this behavior is a bug and has provided the following steps as a work-around:

Set the column type of the column that is changing to a Date column by double-clicking the column name to bring up the Edit Column Properties window. Under Column Type, select Date. This is necessary so that all settings are cleared correctly when it's changed back to the type you want.
Insert two (temporary) columns and set the Column Properties to Date using the same method as step 1.
Right click on any column and select Edit Project Settings. Make note of the columns names listed in the Start and End date column drop-downs as you'll need the names for step 8. (The column that keeps changing should be one of them.)
In the Start date and End date columns drop-downs, select the new temporary Date columns.
Change % Complete to "--None--" if it isn't already.
Click OK.
If you have Conditional Formatting on either of the columns that were listed as the Start or End date, first, make a note of the rules (so they can be recreated after this process) and then delete the rules.
Edit the Column Properties of the columns you made note of in step 3 (these were originally listed in the Project Settings dropdowns for Start date column and End date column) and change them to the property type that the column was in step 1 before it was changed to Date.
Delete the 2 temporary date columns by right-clicking the columns and selecting Delete Column.
Re-apply any conditional formatting rules, if applicable.

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…