<div>
Thank you Bill. That is what I needed. I was missing the difference between the @Contains and @IsMember. I thought also that @IsNotMember and @IsMember was only to be used with UserRoles. &nbsp;I appreciate the education and the prompt answer! &nbsp;Thanks again
</div>


Thank you Bill. That is what I needed. I was missing the difference between the @Contains and @IsMember. I thought also that @IsNotMember and @IsMember was only to be used with UserRoles.  I appreciate the education and the prompt answer!  Thanks again

<div>
<div class="content wysiwyg-content">
I have the following code in a calendar view:<br />
<br />
SELECT ((Form = &quot;Time Off Request&quot;) | (Form = &quot;TimeOff&quot;)) &amp;&nbsp;(@Contains(Add_Calender; &quot;Yes&quot;)) &amp;&nbsp;(@Contains(Type; &quot;Associate&quot;)) &amp;&nbsp;(!@Contains(Status; &quot;Pending&quot;)) &amp;&nbsp;(!@Contains(Team; &quot;LCCC&quot;)) &amp;&nbsp; (!@Contains(Team; &quot;Team Services&quot;)) &amp;&nbsp;(!@Contains(Team; &quot;Mail/Image&quot;)) &amp;(!@Contains(Team; &quot;LRU&quot;)) &nbsp;&amp; (!@Contains(Team;&quot;Team Services/Filing&quot;)) &amp;&nbsp;RequestType !=&quot;Overtime&quot;<br />
<br />
This does work but I am wondering if there is a better way to write the Does Not Contain portion. I have tried this:<br />
<br />
!@Contains(Team;&quot;LCCC&quot;|&quot;Te<wbr />am Services&quot;|Mail/Image&quot;|&quot;LRU<wbr />&quot;) and that does not work. It will not pull any records then at all. &nbsp;Does anyone have any suggestions or am I just missing the boat on how @Contains works.<br />
<br />
Thanks!!!!
</div>
</div>


I have the following code in a calendar view:

SELECT ((Form = "Time Off Request") | (Form = "TimeOff")) & (@Contains(Add_Calender; "Yes")) & (@Contains(Type; "Associate")) & (!@Contains(Status; "Pending")) & (!@Contains(Team; "LCCC")) &  (!@Contains(Team; "Team Services")) & (!@Contains(Team; "Mail/Image")) &(!@Contains(Team; "LRU"))  & (!@Contains(Team;"Team Services/Filing")) & RequestType !="Overtime"

This does work but I am wondering if there is a better way to write the Does Not Contain portion. I have tried this:

!@Contains(Team;"LCCC"|"Team Services"|Mail/Image"|"LRU") and that does not work. It will not pull any records then at all.  Does anyone have any suggestions or am I just missing the boat on how @Contains works.

Thanks!!!!

Help with contains in a formula

Lotus Software produced the Lotus 1-2-3 spreadsheet program, and later developed Lotus Notes, a groupware and email system. Following its acquisition by IBM, the Notes and Domino client/server collaborative platform were expanded to include functions such as email, calendars, to-do lists, contacts management, teamrooms, discussion forums, file sharing, microblogging, instant messaging, blogs, and user directories. IBM also release SmartSuite, a comprehensive office suite, and followed that with Symphony, unrelated to the Lotus suite of the same name.