How to change the date format in the "Last Modified" date column

Taylor Berry

does anyone know if it is possible to change the date formatting in the "Last Modified" date column. It currently shows up as month/day/year which is causing confusion as I work on a global team. Is there a way to make it 21Jul24 for example

Paul Newcome

You would need to use a helper column set as a text/number type with a formula along the lines of:

=DAY([Last Modified]@row) + MID("12JanFebMarAprMayJunJulAugSepOctNovDec", MONTH([Last Modified]@row) * 3, 3) + RIGHT(YEAR([Last Modified]@row), 2)

gwideman

There's a way to do this without such an elaborate formula and achieve almost the same result.

SmartSheet has a toolbar button that allows you to set the format of a column. If that column has data type "Date" then you can set that format to various formats like 21-Apr-2024, or what I prefer, the ISO format 2024-04-21.

The problem is that, inexplicably, SmartSheet didn't implement column format on the "system" columns Created and Modified. What to do?

• Include Modified as a column in your sheet,
• Create a new column, say ModDate, and set its data type to Date (right-click > Column Properties)
• Insert a formula in the first row of that new column: "=Modified@row"
• Right-click > Convert to Column Formula
• Select the column (click column header) and use the Format toobar button to select the date format you want.
• Optionally select the Modified column and right-click > Hide.

Unfortunately you can't implement this solution or Paul's if you don't first upgrade to a Business Plan or higher.

This trivial column formula functionality that could have fixed SmartSheet's glaringly omitted formatting of their own built-in date column is not available in lowly "Team" plan apparently.