Forum Discussion
Calculated Column to populate an Alert
Hi everyone!
I have been trying to do a formula that will show the words "PoP Alert" if Todays Date column is less than or equal to a column titled "Alert Date (Do Not Touch)". I am also trying to add in the formula that if the "Alert Date (Do Not Touch)" column is empty or contains the word "Expired" that it leaves the column blank. Below is the formula I am using but it keeps saying something is wrong with the formula. Any help would be greatly appreciated.
=IF([Alert Date (Do Not Touch)]=”Expired”,"", IF(ISBLANK([Alert Date (Do Not Touch)]),"", [Alert Date (Do Not Touch)]<= [Todays Date (For Formula Only)],”PoP Alert”),””)
2 Replies
- Hi Brian - looks like it could be a formatting issue, you're IFs aren't nested. This is an older article, but still shows a nice nested IF statement https://wendy-neal.com/2014/10/fun-sharepoint-calculated-columns/ Hope that helps!
- Hi Kelly!
Thank you so much for the reply. I will give this a try later today or this evening.
