How to add the word "NEW" appear only today

0 1 116
1 REPLY 1

Add this to the end of the CONCATENATE():

& IF(TODAY()=[dateColumn], " NEW", "")

- replace [dateColumn] with the column from your screenshot.

Top Labels in this Space