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 of work to be provided and scope of work that's not included in the proposal. How do I achieve this?

 

Thanks,

 

Jeff O'Brien

VDC Manager

4 Replies

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor

    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

      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

        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.

Resources