Flag based on multiple columns
I have created a monthly scorecard smartsheet with formulas and conditional formatting to change the color of the cell based on certain criteria. Now I would like to add column with a flag if a KPI is red for 3 consecutive months. Can anyone share how can this be done?
Thanks in advance for your help!