Formula Help

Options

Can someone help be fix the below formula, which keeps coming back as unparseable? I need it to say "Yes" if both of the values in the two specified rows exceed a certain value, and "No" if they do not.


=IF([Impact %]@row>50%]AND[Probability %]@row>50%], "Yes", "No")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!