Seeking automation to auto-update Timeline field (today, tmrw, next week) based on current date

ProductiveTexan

I am seeking to have a smartsheet field for Timeline (Today, Tomorrow, This Week, Next Week, This Month, Next Month) to auto-populate based on the current date. I'm making mistakes remembering to shift timelines week-over-week to the appropriate option and it's then throwing off my timelines. Thanks!

jmyzk_cloudsmart_jp

Hi @ProductiveTexan

Here are the formulas.

https://app.smartsheet.com/b/publish?EQBCT=465fb6fd961e470bb560975ce00ac629

                Start           End

Today	        =TODAY()	=TODAY()

Tommorow	=TODAY(1)	=TODAY(1)

This Week	=TODAY(WEEKDAY(TODAY()) - 1)	=TODAY(WEEKDAY(TODAY()) - 1)

Next Week	=TODAY(WEEKDAY(TODAY()) + 6)	=TODAY(WEEKDAY(TODAY()) + 12)

This Month	=DATE(YEAR(TODAY()), MONTH(TODAY()), 1)	
                =DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1) - 1

Next Month	=DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1)	
                =DATE(YEAR(TODAY()), MONTH(TODAY()) + 2, 1) - 1