Sign in to submit new ideas and vote
Get Started

Date and time formulas

Current Smartsheet formulas are severely limited in dealing with dates and times, and workaround formulas are confusing to read and maintain (e.g. "TODAY(-1 * DAY(TODAY())))".

Allow a standard set of date and time functions like most modern programming languages to parse dates, times and date/time fields.

e.g.:

dayofmonth(date)

month(date)

year(date)

dayofweek(date)

date(string or datetime or day,month,year)

time(datetime)

datetime(string or date)