Tag Info

Hot answers tagged


As I understand your situation, there are three relevant columns: a column with a completion date (let's say it's in column L) column M, which may contain the string COMPLETED a column where you want your output (let's say it's column N) You use the formula =$M2="COMPLETED", which results in TRUE or FALSE. If I understand correctly, instead of ...

Only top voted, non community-wiki answers of a minimum length are eligible