If statement formula problem

Hi QuickBase Community,

I am struggling with a Formula-Duration field in which I'm trying to calculate the number of days since a customer agreement was signed using an if statement conditioned on the type of agreement signed (with its relevant date field), the customer type, and the project status.

If the project is complete and it's a business customer, then I want to show the duration from agreement signed date to completed install date.

If the project is complete and it's a residential customer, then I want to show the duration from the consent form signed date to completed install date.

If the project is not complete, then I just want to show the duration between today and the date the agreement was signed.

My formula results show that the formula is only returning the duration between today and the date the agreement was signed, even when the other conditions are present.

Can someone please help me identify what I've got wrong with my formula?

If(

[Project Status]="Complete" and Contains([Customer Type],"Business"),

[Completed Install Date]-[ Agreement Signed Date],

[Project Status]="Complete" and Contains([Customer Type],"Residential"),

[Completed Install Date]-[ Owner Consent Form Signed],

Today()-[Agreement Signed Date])

Thanks so much!