Formula will function in Excel but not SmartSheet

For some reason I am having trouble getting this formula to function in SmartSheet (even though it works in Excel)...

I am wanting to populate a "Y" in 'Valid Approval?' column only when one of the following 2 situations occur:

1) 'Primary Approval' says "Approved" AND 'Secondary Approval' says "Approved"

2) 'Primary Approval' says "Approved" AND 'Secondary Approval' is blank


Valid approval?    Primary Approval    Secondary Approval

Y                            Approved

N                           Approved                   Submitted

N                           Submitted                 Approved

Y                           Approved                  Approved


This is the formula I wrote that functions in Excel...



Any tips on how I get this to function in SmartSheet?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!