Hello! I am having trouble with the formula below. I am trying to run a compliance check and need to confirm if the clinics are completing their monthly assignments.

The clinics column is the primary list of all clinics at our organization and the reference column has an index/match formula pulling from another sheet to associate if the clinic actually completed their assignment. I am also trying to associate and match the date of the completed assignment, but I am getting an error for #DATE EXPECTED. I've already turned the column into a Date type so I am not sure why I am getting this message... See formula I was using below. Thank you in advance for guidance and assistance!

=IFERROR(INDEX({Ambulatory Manager's Continuous Readiness Range 2}, MATCH(Clinics@row, {Ambulatory Manager's Continuous Readiness Range 2}, 0)), "")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!