Users are receiving alerts successfully from our SharePoint farm. But not surewhere the "email from" address is coming from. I've checked the outgoing emailaddress in Central Administration for all web applications and everything issetup correctly. Is there anywhere else I need to look to find this other emailaddress?
Did you check the Web application settings. If the email is set up in the webapplication settings it will overwrite the System settings.What version Sharepoint are you running so we can respond with the exact pages.
We're running SharePoint 2007.
There is an outgoing email setting for the farm under the Operations tab but youcan also change it for the web application. Its under Application Management- Web Application outgoing e-mail settings.
You can use the sum of IF statements...The syntax is =IF(<condition>, <value_if_true>, <value_if_false>), so...=IF([Col1]=1,1,0)+IF([Col2]=1,1,0)+...