Today Function

holli.nunn

I'm using the Today function to track weekly data counts. I'm wondering if there is a way to use the function to work backward from "Today" instead of forward?

holli.nunn

Ah I think I got it!! Still use =Today()

and the ascending cells have =Date2 - 7

Thank you all! Sometimes just a different perspective helps connect the dots!

Eric Law

@holli.nunn What do you mean? Can you give an example? You can use screenshot to show your columns and what you want it to show as well.

For the Today function, you can do =TODAY(-7) if you want to look at a week ago, or =TODAY(7) if you want a week from now.

holli.nunn

=TODAY()

So instead of looking at future data like above, I want to look at the past.

Andrée Starå

https://community.smartsheet.com/discussion/109789/today-function

Hi,

I hope you're well and safe!

You can do that by adding a minus. =TODAY(-3)

Would that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

holli.nunn

Ah I think I got it!! Still use =Today()

and the ascending cells have =Date2 - 7

Thank you all! Sometimes just a different perspective helps connect the dots!