Can I create an If/Then function such that if the formula is true an email
with a copy of the spreadsheet will automatically be sent to a specified
email address?

Any other suggestions on how to accomplish this sort of task would be
appreciated.