Change colour of a formula box if it’s a year later

Try this in the formula box called Last updated status:

let t := days('Last Updated', today());
styled("Status", if t > 365 then "red" end)

Sure,

---

let t := days('Last Updated', today());
if t > 365 then
styled("Expired", "red")
else
if t < 365 then
styled("Not Expired", "green")
end
end

---

Change the words "Expired" and "Not Expired" to suit your needs

Hi Nick

I hope you don't mind but I would just have

let t := days('Last Updated', today());
if t > 365 then
styled("Expired", "red")
else
styled("Not Expired", "green")
end

Regards John

You're right John, I just wanted to show him the case of multiple ifs...

John/Nick

Both methods work and that is good what you have shown yewani is that there are several ways to achieve the required result - even better !!
In fact, a somewhat wise tutor once told me that when starting out with coding that was better to code it as you are saying it and have the multiple if's etc as it makes it initially easier to follow in your head. Once comfortable with what you are doing then you can go back and refine the code. I think he referred to it as spaghetti code back then cos we often resorted to jumping all over the place! Certainly made for some long coded scripts! before we embarked on proper sub routines etc. :-)

That's beautifully put, as ever Mel