Forum Discussion

ChrisChris's avatar
ChrisChris
Qrew Assistant Captain
8 years ago

Counting selections in multi select text field...

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...
Formulas and functions
ChrisChris's avatar
ChrisChris
Qrew Assistant Captain
8 years ago
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