Can someone help me with this syntax:
IF( ISPICKVAL( Type , OR('Block Number', 'Unknown Number')), 1, 0)
I am receiving the following error message:
Incorrect number of parameters for function 'ISPICKVAL()'. Expected 2, received 3 (Related field: Formula)`
I usually use:
IF( ISPICKVAL( Type ,'Block Number'), 1, IF( ISPICKVAL( Type , 'Unknown Number'), 1, 0)
but there are limited amount of characters one can use in a formula field.