Flag is others are flagged
I have an "At Risk" column and I want one row to flag if any in a set range of others are flagged. For example, on a project template, I have a "Planning Milestone"; I want the milestone to flag if any rows within the "Planning" phase are flagged. I was attempting to use a formula like this:
=IF([At Risk]95:[At Risk]98 = 1, 1, 0)
But I either get a circular reference error or an invalid operation error.