Formula To mark a row as recent
Hello,
I would like to type the word recent into a cell based on it being recent(created date is in the last 7/ days).
Otherwise I want the Cell to be blank.
This is what I tried but get #UNPARSEABLE
=IF([Created]246>=TODAY(-7), "Recent", false)
I'm working in a quotes sheet that can get very long and I want to create a view which only show rows where the quote has an order (order column has an order number) and where it is a recent quote (created date is last 7 days). This can't be achieved with a view as it is either BOTH or EITHER statements are to be true and we could have old quotes with an order number in the order column that we want to see.
So I thought I would put a formula in the order column like the above and have the view only show rows where the order column is populated with something.. Order number or the word recent....
Thanks for your time in advance. I hope you can help.
Deirdre
Comments
-
Try this rendition. the Today() function shouldn't have anything in the parenthesis and then you can use -7 to subtract that from today. Also, you needed to put false in quotes. Otherwise, you were definitely on the right track.
=IF([Created]246>=TODAY()-7, "Recent", "false")
-
@Mike, you are correct about the quotes around "false" - that is what was producing the error.
While TODAY() - 7 DOES work in this instance, the parenthesis are used to add or subtract days from the TODAY() function.
Best practice is to write it like this: TODAY(-7)
-
Thanks, Travis. I did not know that about the Today() function. I rarely use it! Good to know.
-
Thanks Mike and Travis, I really appreciate your help.
FYI: I changed it to the below so that the cell would be empty if it was not recent (created in last 7 days).
=IF(Created1 >= TODAY(-7), "Recent", "")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!