Kelli Webb
Member
Hi, I would like the below formula to also include a provision for when a date in Column C is populated, Column D will change to Closed.
=IF(B2="Continuation",B2,IF(ISBLANK(C2),"Open","Closed"))
Thank you for your assistance!!
=IF(B2="Continuation",B2,IF(ISBLANK(C2),"Open","Closed"))
Thank you for your assistance!!