Role Play, practice, call an investor friend every morning and run your scripts.

Additionally, if I were to leave leasing, is it possible to transition to an investing style role?

Your situation is complicated in that your son's existing interest, even minority, may ultimately disqualify the partnership for your IRA because of his role or existing profits interest.The big picture you need to understand is that when partnering your IRA funds with your son, be sure that the investments are arms length and structured in an undivided interest.

if so, how far6) would you consider a passive role in the real estate investment?  

It is an enormous responsibility taking on the role as a landlord.

I mainly use spreadsheets to handle my data now and I'm pretty handy with Excel Filters, Pivot tables and basic macros. 

Realize the tenant plays huge role in this as well by cleaning and heating their clothing and bedding but not sure how else to proceed?

If you want to avoid this, you will need to be very careful how you structure your agreement and what role the CA partner plays.  

I signed the contract and waited.October 10th: reached out to be sure my contract was effectiveI didn't hear back and usually am used to a more active role with this kind of stuff.

Aside from asset protection, we also want to make sure the role for each sister is clearly defined in the operating agreement, just to prevent future confusions and arguments.