On my phone so I can’t write out the full thing, but I don’t think you need AND() or OR(). It could all be one big nested IF().

You’d want to reverse it, though - start with checking the {4th Pupdate} field. An IF() statement is going to stop evaluating after the first condition that returns true. If you start by evaluating {1st Pupdate}, the formula will never even look at the 2nd, 3rd or 4th dates because once the 1st date passes, it will get stuck at “🔴 1st Overdue”. This is of course assuming that each “Pupdate” is after the next.

Hmm, you could try combining the IFs with an "&" instead, then in a situation where both the first and second are due soon, the field would output:

And so your email would just send that?

Hi,
As @TheTimeSavingCo said, you can just connect them with &
Output will be the status of all 4, so you might want to change a bit, like

IF({1st Pupdate}, "1st update: "&
  IF(IS_AFTER(TODAY(), {1st Pupdate}), "🔴 1st Overdue", IF(IS_SAME(TODAY(),
  {1st Pupdate}), "📆 Due Today", IF(IS_AFTER(TODAY(), DATEADD({1st
  Pupdate}, -1, 'week')), "⚠️ Due Soon","👌 OK")))
&"\n")

Thanks for this  @Alexey_Gusev but when I put the formula in which includes all the other pupdates every entry has the 1st update reference in it! it doesn't seem to go past the first IF!! (I have even done the entries backwards as suggested above!)

Hi  @AlliAlosa , if you have 5 minutes, please could you spare the time and write it out for me as I still can't get it to work!! LOL!

For those that need something similar... this formula works nicely: Thanks to everyone's input - it all helped 🙂