<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Code</title><link>https://www.infopathdev.com:443/forums/45.aspx</link><description /><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Validation formula error</title><link>https://www.infopathdev.com:443/forums/thread/120547.aspx</link><pubDate>Thu, 07 Mar 2019 20:51:15 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:120547</guid><dc:creator>Gabrielle Souza</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/120547.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&amp;PostID=120547</wfw:commentRss><description>Hi everybody,

I&amp;#39;m newbie in Sharepoint Development and customizations, and I need some help from you guys. If you, please, could help me I&amp;#39;ll be so thankful!

My client asked me to add a column validation on his sharepoint online list. The validation is when the column RAG Status is not equal to Green, the column Back To Green must have a value.

I searched on many sites and, in meu lab this formula worked so well. When I tried on my client environment, I got the error: &amp;quot;Sometinhg went wrong...&amp;quot;

Here&amp;#39;s the formula:
=SE([RAG Status]&amp;lt;&amp;gt;&amp;quot;Green&amp;quot;;SE([Back To Green]=&amp;quot;&amp;quot;;FALSO;VERDADEIRO);VERDADEIRO) or
=IF([RAG Status] &amp;lt;&amp;gt; &amp;quot;Green&amp;quot;;IF([Back to Green]=&amp;quot;&amp;quot;;FALSE;TRUE);TRUE)</description></item></channel></rss>