Forum Discussion

JoeLangley12's avatar
JoeLangley12
Copper Contributor
Oct 20, 2022
Solved

Populating a cell when other cells are populated/not populated

Hi. I was wondering if someone could help me. I’m trying to populate a cell with the word “Completed” on the condition that 4 other cells are populated (Not Blank).   However, I want this same c...
  • OliverScheurich's avatar
    Oct 20, 2022

    JoeLangley12 

    =IF(COUNTBLANK(A2:D2)>0,"not completed","completed")

    You can try this formula.

Resources