=IF(COUNTIF(BlueSheet!K:K,"Adversary")+COUNTIF(BlueSheet!K:K,"Enemy")>0,"RED FLAG","OK")
If you don’t want to build from scratch, search for: miller heiman blue sheet excel
A standard Blue Sheet template typically includes these core sections to structure the sales strategy: Single Sales Objective (SSO): =IF(COUNTIF(BlueSheet