Skip to main content
Question

Counting selections in multi select text field...

  • July 13, 2017
  • 0 replies
  • 41 views
Hi,
I have the following formula numeric field to count the number of times, up to three, I have sent a notification to someone::

===
If(Contains(ToText([Sent Invitation Today-Notice to Requestor]),"1st notification to requestor"),1,null)+
If(Contains(ToText([Sent Invitation Today-Notice to Requestor]),"2nd notification to requestor"),1,null)+
If(Contains(ToText([Sent Invitation Today-Notice to Requestor]),"3rd notification to requestor"),1,null)
===

The formula saves without error, but does not return anything and it should. Can someone tell me what I'm doing wrong?
Thank you,
Chris
    This topic has been closed for replies.

    • ChrisChris
    • Author
    • Registered
    • July 13, 2017
    Figured it out. The code should read::

    ===
    If(Contains(ToText([Sent Invitation Today-Notice to Requestor]),"1st notification to requestor"),1,0)+
    If(Contains(ToText([Sent Invitation Today-Notice to Requestor]),"2nd notification to requestor"),1,0)+
    If(Contains(ToText([Sent Invitation Today-Notice to Requestor]),"3rd notification to requestor"),1,0)
    ===

    Can't add a null apparently. 
    Thank you for your support.
    Chris
    Terms & ConditionsAccessibility statement