Forum Discussion

Dan_Mc's avatar
Dan_Mc
Copper Contributor
Jun 19, 2019
Solved

Auto populate text in a cell

Hello all,   I'm trying to have text auto populate in a cell based of off three cells in the same row.  I'm want to use it a checklist feature in a progress tracking document.  The idea is the row ...
  • SergeiBaklan's avatar
    Jun 19, 2019

    Dan_Mc 

     

    Did you try

    =IF(COUNTIF(B2:D2,"Y")-3,"N","Y")

    ?

Resources