Possible IF/AND question

Hi team

I have 2 sheets - Detailed Monthly Inspection and Monthly Inspection Score.

I want the Monthly Inspection Score sheet to be able to look at the Detailed Monthly Inspection sheet and return the percentage for each store on a month by month basis, as the inspections are completed.

I think it might need to be an IF/AND equation but I keep getting an 'invalid operation' error. This is the equation I'm using and would like some help on:

=IF(AND({ClinicName} = "Botany Downs Clinic", {Month} = "May"), {Percentage})

If the clinic name is Botany Downs, and the month the inspection was completed is May, return the percentage score.

Any assistance would be appreciated.

Thanks, Sharyn


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!