Formula To mark a row as recent
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.