Need to look at a date and check box based on 3 criteria

I am trying to make a formula that looks at a date field and checks box if

1) Task date is over 3 years ago;

2) Retired isn't checked;

3) Type is a specific kind (Type S)

I can get the first part to work but I always run into problems with IF statements that have multiple criteria.

=IF(ISDATE([Task Last Completed]@row), IF([Task Last Completed]@row <= TODAY(-1096), 1)) is what I currently have that works but it doesn't look at the two additional criteria I need it to.

I've attached a screenshot of my sheet. The above formula is in the Over 3 years column.

Any help would be greatly appreciated.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!