How to Format Salesforce Date in Smartsheet for 30-Day Archiving Automation

Question

Hi there,

I have a sheet that pulls in Department Events via Data Shuttle from Salesforce. The issue is that I want events to archive off the sheet after 30 days. However, the date format coming in looks like this: 2026-03-16T00:00:00.

Smartsheet automation doesn’t recognize this format. I tried creating a helper column to convert it using:

=DATE(LEFT([Single-Day Event Start]@row,4),MID([Single-Day Event Start]@row,6,2),MID([Single-Day Event Start]@row,9,2))

But that didn’t work. My question is: how can I format this date field so it’s recognized as a proper date (MM/DD/YY) and can be used to archive rows after 30 days?

The automation I plan to use is “When a date is reached.”

=[Single-Day Event Start]@row + 30

LeelaLodhi03 · Accepted Answer

Hi @Brittanyy ,

You can check if this formula works for your case:

=DATE(VALUE(LEFT([Single-Day Event Start]@row, 4)), VALUE(MID([Single-Day Event Start]@row, 6, 2)), VALUE(MID([Single-Day Event Start]@row, 9, 2)))

Hope this helps! 🙂

LeelaLodhi03 · Accepted Answer

If this works, You can simply add 30 days to your helper column formula to extend the date by 30 days.

=DATE(VALUE(LEFT([Single-Day Event Start]@row, 4)), VALUE(MID([Single-Day Event Start]@row, 6, 2)), VALUE(MID([Single-Day Event Start]@row, 9, 2))) + 30

Paul Newcome · Accepted Answer

@Brittanyy The DATE function requires numerical values as the inputs. Text based functions such as LEFT, RIGHT, and MID output text. Try wrapping each of those pieces in VALUE functions.