
Save Time – Every Day

If you’re building big spreadsheets and need to add dates, but you are unsure of what they are, you can type the following text values into a Date Formatted column to enable Smartsheet to help you do this automatically:
“Tomorrow” -> will return a date 1 day into the future
“Yesterday” -> will return a date 1 day from the past
“Next week” -> will return a date 7 days into the future
“Last week” -> removes seven days
“Next Month” -> adds one month
“Last month” -> removes one month
“Next Year” -> adds a year
“Last Year” -> decreases the date by one year
“Week 2” -> inserts a date that corresponds to first day of week 2 of the year
“1” -> enters the first day of the current month
These dates are NON changing. So once they are in, they stay! Give it a go and let us know what you think!












