Return Data based on two conditions being met


Please can you assist with a formula that checks data from two cells within a sheet that will then populate a matrix sheet. The data sheet is being populated via form currently.

If Property Name is "Mykonos" and if Quarter 2, then return the % Score

I keep getting "Incorrect Argument Set Errors" :(

In the Matrix, I will have all the property names populated and will need to return the score achieved based on the quarter submitted.

Thanks in advance for your assistance

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!