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

Find more posts tagged with

Formulas

IT & Operations

Comments

Mike Wilday

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")

Travis

@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)

Mike Wilday

Thanks, Travis. I did not know that about the Today() function. I rarely use it! Good to know.

Deirdre

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", "")

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?