Introducing Checkboxes in Excel

Would you know how soon the checkbox feature will be available for GCC tenants? Thanks. 

How would I make a logical function that when a checkmark on, for example: worksheet "Job Status" is checked (True), it takes the row of the filled checkbox and copy and pastes it into another worksheet, in this case, "Outstanding Drawings". With each checkbox pasting onto the next available row starting from A1.

SBrawford, Checkboxes like other features of ours, are released channel by channel.

You're likely seeing them on your home subscription because you're on Current Channel, which is the default. They are not yet available on Monthly Enterprise or Semiannual Enterprise channels, which you're most likely on at work (your choice of channel is typically set by your M365 Admins - they can even select Current Channel).

The good news: Checkboxes should be available in the Monthly Enterprise Channel in the next month, and should be in the next Semiannual release as well (in ~Jan/Feb) - although this is always subject to change.

Thank you for your patience and for sharing your interest in Checkboxes!

I guess I'm wondering after announcing these new checkboxes in early October of 2023 that over a year later, some 365 subscription users, especially those who have the enterprise subscription which tends to be more business related, don't have access to this relatively simple update yet.  I have it at home on my personal computer with the regular 365 subscription, but at work where I could use it the most, we may not have another update which adds this until beginning of 2025?

FerdVega , I guess it's semi-annual channel. It is updated by feature twice per year, in Jan-Feb and Jun-Jul as I remember. Thus the earliest at the beginning of next year, more probable in the mid of it. Or update on Current channel.

Anyone know when this will be available for 365 Version 2308? I NEED THIS!!!😭

You can also create a checkbox toggle with Wingdings (o in Wingdings is a blank checkbox, x in Wingdings is a filled checkbox). 

I made a video about how to do this, but if you just want the code, I have that below too.  I used the Wingdings in Column C, just make sure to revise the code as needed. 

YouTube Video: https://youtu.be/sgDZvJlooVU 

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    ' Specify the range where the checkboxes are located (column C)
    If Not Intersect(Target, Me.Range("C:C")) Is Nothing Then
        Cancel = True ' Prevents entering edit mode on double-click
        
        ' Check if the font is Wingdings and if it is a checkbox (either "o" or "x")
        If Target.Font.Name = "Wingdings" Then
            If Target.Value = "o" Then
                ' If the value is "o", change it to "x" (checked box)
                Target.Value = "x"
            ElseIf Target.Value = "x" Then
                ' If the value is "x", change it back to "o" (unchecked box)
                Target.Value = "o"
            End If
        End If
    End If
End Sub

I found my mistake! Thank you JakeArmstrong. I use french version and don't take the good formula I used SUMIF instead of COUNTIF -_-

jpcanuel, COUNTIF should work for you in this situation.

For example, with checkboxes in A1 through A5, you can use either of these formulas:

=COUNTIF(A1:A5,TRUE) to count TRUEs or =COUNTIF(A1:A5,FALSE) to count FALSEs
=SUM(A1:A5*1) can also be used to count TRUEs, because TRUE*1 = 1

Note for more advanced cases:

COUNTIF only accepts ranges/references, not arrays, so if you are creating A1:A5 with functions inside the COUNTIF, it won't work as expected. If you are using a reference to the grid (eg A1:A5 in this example), this doesn't apply and COUNTIF should work fine for this use case.

Hi JakeArmstrong ,

I use the new feature Check box but I'm not able to count the TRUE or FALSE answer(check or no check). It's always 0, I try with =COUNTIF(C2;FALSE), I try to create a new column with =C2 to extract the text not working and =IF(C2;1;2) in a new column to extract a number but I only receive 2 for answer. I don't know if I don't understand something or make a mistake. 

Thank you for your help!