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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!