Configuring (TODAY() Function
Hi Community,
I'm trying to create a formula that if [Column 2]@row is within the last 7 days of the Created@row, it will calculate the SUM of [Column 2]@row,
I tried the below, but I see that it also gives me the same information if created would be in the future
(I added a test date column and put the [created test] date in the future, and it also gave me the SUM)
So if a row is added today, it will show the data from today, but I only want it to show if Created is more than 7 days ago.
=SUMIF(TODAY(-7), <=Created@row, [Column 2]@row)
Please assist.
Thank you!
Best Answers
-
Try this instead...
=IF(Created@row >= TODAY(-7), [Column 2]@row)
Really though, if you are using the Created column that is automatically entering the date/timestamp for when the row is created, it shouldn't matter what the formula does with dates that are in the future because the Created column will never have a future date in it.
-
Hi Paul,
just removed the <.
Thank you!
Answers
-
Try this instead...
=IF(Created@row >= TODAY(-7), [Column 2]@row)
Really though, if you are using the Created column that is automatically entering the date/timestamp for when the row is created, it shouldn't matter what the formula does with dates that are in the future because the Created column will never have a future date in it.
-
-
Hi Paul,
just removed the <.
Thank you!
-
@A Rose Yuppers. Happy to help and glad you got it figured.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!