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...

=IF((COUNTIF(C2,"Approved")+COUNTIF(D2,"Approved"))*OR(COUNTIF(D2,"Approved")+COUNTIF(D2,"")),"Yes","No")

 

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

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!