Forum Discussion

Jeff O'Brien's avatar
Jeff O'Brien
Copper Contributor
May 22, 2018

Autopopulate text with check boxes into another cell

I've been asked if its possible to have a complete list of data within a spreadsheet off the print area. When we check pieces of the data, we want them to auto-populate into cells that show a scope o...
Excel - formulas data worksheet
Matt Mickle's avatar
Matt Mickle
Bronze Contributor
May 22, 2018

Jeff-

 

This is certainly possible.  Depending on your situation things could be pretty simple or pretty complex.  I have attached a simple version (See .xlsx attachment) that demonstrates the concept. You would probably need to provide more detail for your particular situation or use my example file in context with the way your data is structured.  Hope this helps.

 

 

 

  • Jeff O'Brien's avatar
    Jeff O'Brien
    Copper Contributor
    May 22, 2018

    Basically what I'm trying to do is to autopopulate text into the scope included section and the not included section of the attached document. We constantly bid specification sections for construction projects. It would be helpful if I could just check what sections are included and have them autopopulate the correct scope included box. If their unchecked then they belong in the not included section. 

     

    Make sense? Or am I confusing everyone?

    • Matt Mickle's avatar
      Matt Mickle
      Bronze Contributor
      May 31, 2018

      Hey Jeff-

       

      Just wanted to follow up and see if you were still having issues with your workbook?  If so, please feel free to reach back out to the community and ask additional questions.

    • Matt Mickle's avatar
      Matt Mickle
      Bronze Contributor
      May 22, 2018

      Jeff-

       

      Try using a few array formulas in conjunction with the checkboxes (See attached ):

       

      Formulas must be committed with CTRL + SHIFT + ENTER

       

      Formula for Included:

      {=IFERROR(INDEX($J$9:$J$14,SMALL(IF($K$9:$K$14=TRUE,ROW($K$9:$K$14)-ROW($K$9)+1),ROWS($K$9:$K9))),"")}

       

      Formula for not included:{=IFERROR(INDEX($J$9:$J$14,SMALL(IF($K$9:$K$14=FALSE,ROW($K$9:$K$14)-ROW($K$9)+1),ROWS($K$9:$K9))),"")}

       

       

       

Resources