I have a SharePoint list that accepts incoming email and has two calculated columns based on the Email Subject.
Immediate alerts, RSS etc all work fine but the Weekly Summary Alert has #VALUE! for all the calculated columns.
Is there a reason for this? Can I get it to show that actual calculated value?