Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

IF/AND Statement to yield check box answer

R. Shields
edited 12/09/19 in Archived 2017 Posts

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.


This discussion has been closed.