+ Reply to Thread
Results 1 to 2 of 2

Code to get google Sheets to automatically fill a box if 4/5 other boxes are filled.

  1. #1
    Registered User
    Join Date
    11-30-2022
    Location
    Lancaster, CA
    MS-Off Ver
    Office 365
    Posts
    1

    Code to get google Sheets to automatically fill a box if 4/5 other boxes are filled.

    Hello,
    I am trying to help another teacher with Google Sheets. She is trying to do a sheet where when students complete work for the day she puts a check mark. She would like it to automatically fill a box off to the right for each subject if the students complete 4 of the 5 days of work. Each subject has 5 check boxes using true or false. One box is for each day of the week (M-F). She would like a code that if 4 of the 5 are completed it will then fill a box further to the right to show they got credit for the week in that subject. I put a document that allows you to copy the google sheet as an attachment.
    I am not sure how to code each subject to get the end result that she would like. Would appreciate any help.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Code to get google Sheets to automatically fill a box if 4/5 other boxes are filled.

    Due to the fact hat solutions for Google Sheets can not always be built in Excel and therefore will require a Google Sheets file to be constructed, I wont provide support for Google Sheets in an Excel file.

    HOWEVER, i have created this file for you to build your sample in:

    https://docs.google.com/spreadsheets...gid=2100307022
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Google Sheets: Mix Boxes Fit into Box
    By Swaski in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 08-29-2022, 07:54 PM
  2. Budget display according to items filled
    By Rafaelpresa123 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-24-2020, 05:48 PM
  3. [SOLVED] VBA Code to Auto Fill Down till Next Filled Cell & reapply the code with new value
    By Ram_G in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-24-2016, 06:20 AM
  4. Replies: 2
    Last Post: 10-11-2012, 04:49 PM
  5. Replies: 1
    Last Post: 05-12-2010, 05:45 PM
  6. Automatically count how many boxes are filled in
    By Feline2001 in forum Excel General
    Replies: 2
    Last Post: 11-10-2008, 09:38 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1