3w1h Format In Excel Link -

: Assigns the responsible party, target audience, or stakeholder.

If you have sheets named Week1 , Week2 , Week3 , each with identical 3W1H structure: 3w1h format in excel link

=IF(ISERROR(INDIRECT(SUBSTITUTE(CELL("address",E2),"#",""))), "Broken","OK") : Assigns the responsible party, target audience, or