IF/AND Statement to yield check box answer

R. Shields

Hi Smartsheet wizards.

 

I am trying to create a formula for the following logic to track my teams contact with clients. Essentially if a team member hasnt contacted a client within 30 days, to produce a check mark. We have a small team so I planning on copying this formula to a seperate column per team member and then selecting a Notification to alert the team member if they are in excess of 30 days.

 

The following is the formula I have pieced together.

 

=IF(AND([PRIMARY CHAMPION]2 = "Bill", [DATE BETWEEN]2 > 30, 1, 0))

 

This formula returns an #INCORRECT ARGUMENT SET

 

I appreciate the help with correcting my mistakes.

J. Craig Williams

Your last parenthesis is in the wrong place.

 

=IF (  AND (  ), 1, 0 )

 

If that doesn't work, I'll build it and test.

 

Craig

R. Shields

Thanks Craig. That worked perfectly. 

 

Much appreciated