Here’s what I came up with:
![Screen Shot 2020-01-24 at 7.01.52 AM Screen Shot 2020-01-24 at 7.01.52 AM](/t5/image/serverpage/image-id/14823i843CB915E27F75E0/image-size/large?v=v2&px=999)
I went with two formula fields: one to calculate the date difference between {Use by Date}
and the current day, and another to use that difference to decide how to flag each item. This could all be done in a single formula, but whenever I’m using the same calculation several times, I prefer to throw that into its own formula field and treat it like a programming variable. {Diff}
is this:
DATETIME_DIFF({Use by Date}, NOW(), "days")
And {State}
is this:
IF(Diff <= 0, "❌", IF(AND(Diff > 0, Diff <= 28), "⚠️"))