How to check consecutive rows and flag if not blank

Hi All,

I have a sheet where I'm tracking utilization on a weekly basis.

I need to check if utilization gets over a threshold on 3 consecutive rows.

but I'm not sure how to do this.

In the example below Row 7 should have something on the "Alert?" Column, as it passed the threshold 3 times in a row.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!