Formula That References Another Sheet

Ned Flanders

I am trying to create a formula to track task completions that will reference another sheet. And if all is true, check mark the box next to their names

• If Completed Date from sheet 2 is within or equal to 30 days of Due Date on sheet 1, then check mark Completed box.

Thank you for your support.

Paul Newcome

Are you able to provide screenshots for context?