Hi I'm trying to use a formula that works in excel to work in smartsheet

This is the formula

=IF([Actual Test Date]1 >= "", "MSA Required", IF(AND([Next MSA ]1 = "x"), "MAS Required", IF(AND([Actual Test Date]1 < [MSA Due Date]1), "MSA Completed", IF([Actual Test Date]1 > [MSA Due Date]1, "MSA Late", "MSA Completed"))))

but it gives #invalid operation... It look likes it is using the first statement then ignoring the following ifs.

Any help will be greatly appetited.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!