You need to sign in to do that
Don't have an account?

Nested If Not Working
Hey guys,
This formula:
IF(AND(ISBLANK( Prospect_First_Name__c ),OR((ISPICKVAL(StageName,'Proposal Sent')),(ISPICKVAL(StageName,'Portfolio Analysis')),(ISPICKVAL(StageName,'Decision Stage')),(ISPICKVAL(StageName,'Account Implementation')))),"I wanted to follow-up and make sure you received and reviewed our proposal outlining how we might be able to provide your prospect with "+ Strategy_2__c +" solutions. Are there any other questions or concerns I can address? What are the next steps? I look forward to hearing from you,",IF(AND(NOT(ISBLANK( Prospect_First_Name__c )),OR((ISPICKVAL(StageName,'Proposal Sent')),(ISPICKVAL(StageName,'Portfolio Analysis')),(ISPICKVAL(StageName,'Decision Stage')),(ISPICKVAL(StageName,'Account Implementation')))),"I wanted to follow-up and make sure you received and reviewed our proposal outlining how we might be able to provide " + Prospect_Full_Name__c + " with "+ Strategy_2__c +" solutions. Are there any other questions or concerns I can address? What are the next steps? I look forward to hearing from you,",IF(OR(ISPICKVAL((StageName,'Open')),(ISPICKVAL(StageName,'OSG New'))),"I wanted to follow-up from our discussion to make sure I had addressed all your questions regarding available OSG solutions. Are there any concerns I can address? What are the next steps? I look forward to hearing from you,","")))
is returning a Missing Parentheses error, and I'm not sure why, it seems like everything lines up. Thanks for the help!!
This formula:
IF(AND(ISBLANK( Prospect_First_Name__c ),OR((ISPICKVAL(StageName,'Proposal Sent')),(ISPICKVAL(StageName,'Portfolio Analysis')),(ISPICKVAL(StageName,'Decision Stage')),(ISPICKVAL(StageName,'Account Implementation')))),"I wanted to follow-up and make sure you received and reviewed our proposal outlining how we might be able to provide your prospect with "+ Strategy_2__c +" solutions. Are there any other questions or concerns I can address? What are the next steps? I look forward to hearing from you,",IF(AND(NOT(ISBLANK( Prospect_First_Name__c )),OR((ISPICKVAL(StageName,'Proposal Sent')),(ISPICKVAL(StageName,'Portfolio Analysis')),(ISPICKVAL(StageName,'Decision Stage')),(ISPICKVAL(StageName,'Account Implementation')))),"I wanted to follow-up and make sure you received and reviewed our proposal outlining how we might be able to provide " + Prospect_Full_Name__c + " with "+ Strategy_2__c +" solutions. Are there any other questions or concerns I can address? What are the next steps? I look forward to hearing from you,",IF(OR(ISPICKVAL((StageName,'Open')),(ISPICKVAL(StageName,'OSG New'))),"I wanted to follow-up from our discussion to make sure I had addressed all your questions regarding available OSG solutions. Are there any concerns I can address? What are the next steps? I look forward to hearing from you,","")))
is returning a Missing Parentheses error, and I'm not sure why, it seems like everything lines up. Thanks for the help!!
Please try this below
IF(AND(ISBLANK( Prospect_First_Name__c ),OR(ISPICKVAL(StageName,'Proposal Sent'),ISPICKVAL(StageName,'Portfolio Analysis'),ISPICKVAL(StageName,'Decision Stage'),ISPICKVAL(StageName,'Account Implementation'))),"I wanted to follow-up and make sure you received and reviewed our proposal outlining how we might be able to provide your prospect with "+ Strategy_2__c +" solutions. Are there any other questions or concerns I can address? What are the next steps? I look forward to hearing from you,",IF(AND(NOT(ISBLANK( Prospect_First_Name__c )),OR(ISPICKVAL(StageName,'Proposal Sent'),ISPICKVAL(StageName,'Portfolio Analysis'),ISPICKVAL(StageName,'Decision Stage'),ISPICKVAL(StageName,'Account Implementation'))),"I wanted to follow-up and make sure you received and reviewed our proposal outlining how we might be able to provide " + Prospect_Full_Name__c + " with "+ Strategy_2__c +" solutions. Are there any other questions or concerns I can address? What are the next steps? I look forward to hearing from you,",IF(OR(ISPICKVAL(StageName,'Open'),ISPICKVAL(StageName,'OSG New')),"I wanted to follow-up from our discussion to make sure I had addressed all your questions regarding available OSG solutions. Are there any concerns I can address? What are the next steps? I look forward to hearing from you,","")))
Thanks
Jothi
Sweet Potato Tec.
All Answers
Please try this below
IF(AND(ISBLANK( Prospect_First_Name__c ),OR(ISPICKVAL(StageName,'Proposal Sent'),ISPICKVAL(StageName,'Portfolio Analysis'),ISPICKVAL(StageName,'Decision Stage'),ISPICKVAL(StageName,'Account Implementation'))),"I wanted to follow-up and make sure you received and reviewed our proposal outlining how we might be able to provide your prospect with "+ Strategy_2__c +" solutions. Are there any other questions or concerns I can address? What are the next steps? I look forward to hearing from you,",IF(AND(NOT(ISBLANK( Prospect_First_Name__c )),OR(ISPICKVAL(StageName,'Proposal Sent'),ISPICKVAL(StageName,'Portfolio Analysis'),ISPICKVAL(StageName,'Decision Stage'),ISPICKVAL(StageName,'Account Implementation'))),"I wanted to follow-up and make sure you received and reviewed our proposal outlining how we might be able to provide " + Prospect_Full_Name__c + " with "+ Strategy_2__c +" solutions. Are there any other questions or concerns I can address? What are the next steps? I look forward to hearing from you,",IF(OR(ISPICKVAL(StageName,'Open'),ISPICKVAL(StageName,'OSG New')),"I wanted to follow-up from our discussion to make sure I had addressed all your questions regarding available OSG solutions. Are there any concerns I can address? What are the next steps? I look forward to hearing from you,","")))
Thanks
Jothi
Sweet Potato Tec.
Please try this below Code:
Please like and mark it as best if you find it helpful.
Thanks
Jolly Birdi