• Ariana Vega
  • NEWBIE
  • 10 Points
  • Member since 2018

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies
Hi all!
Today I am wondering if anyone can help me with something quite simple.  I am trying to create a formula checkbox field in my contact object that relates to fields in the same contact object.

This formula field should be checked off IF contacts have completed 1 computer training or if they've completed both.

I started off with a formula similar to this,

IF(
AND (
 Digital_Lit_101__c, 1,
 Digital_Lit_201__c, 1,
0) = 0,

but get stuck at this stage. I also tried this formula,

IF( Digital_Lit_101__c , 1, 0,
  IF(  Digital_Lit_201__c  , 1, 0, "")
)

But get this error message,  Error: Incorrect number of parameters for function 'IF()'. Expected 3, received 4.

If anyone can provide assistance it would be greatly appreciated!
Thank you!
 
Hi all!
Today I am wondering if anyone can help me with something quite simple.  I am trying to create a formula checkbox field in my contact object that relates to fields in the same contact object.

This formula field should be checked off IF contacts have completed 1 computer training or if they've completed both.

I started off with a formula similar to this,

IF(
AND (
 Digital_Lit_101__c, 1,
 Digital_Lit_201__c, 1,
0) = 0,

but get stuck at this stage. I also tried this formula,

IF( Digital_Lit_101__c , 1, 0,
  IF(  Digital_Lit_201__c  , 1, 0, "")
)

But get this error message,  Error: Incorrect number of parameters for function 'IF()'. Expected 3, received 4.

If anyone can provide assistance it would be greatly appreciated!
Thank you!