Smartsheet Tips: How to Use the Checkbox Formula


Smartsheet Tips: How to Use the Checkbox Formula

Last week we introduced a few ideas for keeping your completed tasks organized. This week, we’re taking organization to the next level by walking you through a way to use the checkbox formula to stay on top of things in Smartsheet.

Candice Santomauro, Director of Program Development at, uses Smartsheet to stay on top of her busy world, in particular to stay organized during fundraising activities. Santomauro tracks all communication touchpoints with donors, from invitations and fundraising dinners to Christmas cards, in Smartsheet.

One easy way to track progress on all these touchpoints is to use "Checkbox columns" to indicate (or check off) when the annual report or Spring Fundraiser invites are sent.

By adding a checkbox formula, you can automate a sheet to count total number of invites sent – or anything else you can check off. Let's walk through how Santomauro could use the checkbox formula to keep track of invitations sent for’s Spring Fundraiser.

In this example, the pink row with “Spring Fundraiser Invite List” is the parent row.  In the “Invite Sent?” column in the parent row, enter the formula:

="Total Sent: " + COUNTIF(CHILDREN(), 1)

With this formula applied, your sheet will automatically calculate the total number of invitations sent. It’s as easy as that.

This is just the beginning of the possibilities available with formulas in Smartsheet.  In the coming weeks, we’ll walk you through many more ways you can use formulas to automate your sheets. 

In the meantime, our Help Center has some basic information about formulas.  To help you get going with formulas in your own sheets, we built this template as a list of all of the formulas that work in Smartsheet.  It’s a great reference to have when experimenting in your sheets for the first time.

If you’ve got some time on your hands and are ready to learn even more, this instructional video will walk you through more of the ins and outs of formulas in Smartsheet: 



Til next time, dig in and explore!

- Support Team



Multiple checklist columns

We use a tool called a "Red Dot/Green Dot" spreadsheet. It has rows along the side with every client's name. The columns are products from us that they either have purchased (green dot) or havent purchased yet (red dot). If I put columns of check boxes, couldn't we see at a glance how many clients have purchased each product? or any product if we included prospects in our rows?

Re: Multiple checklist columns

Kelly Anthony's picture
Hi Becky, Yes, you can certainly add in a checkbox column with this formula. You can also apply a similar formula on your RYG columns: Use =COUNTIF([RYG Column]:[RYG Column], "Red") to count all of the rows that contain red balls or =COUNTIF([RYG Column]:[RYG Column], "Green") to count all of the rows that contain green balls. If you run into any snags, feel free to email us directly to troubleshoot: Good luck!

Checkbox Formula

This may be obvious, but just in case If you don't want any text in front of the Count the formula is ="" + Countif(children(), 1) When you leave out the "" + you just get a checked box

Checkbox formula

Hello Kelly We are trying to arrange a formula that ensures the checkbox in the parent row becomes checked once all the children checkboxes are checked, but not before. We tried many ways, but always had missing parameters, would you be able to help? Many thanks Andrew

Checkbox filled if children are checked

=IF(COUNTIF([Row_Name]41:[Row_Name]46, 1) = COUNT([Row_Name]41:[Row_Name]46), 1, 0) The last 1, and 0 are the IF_True, or IF_False case. The value 1 will fill in the parent checkbox, while the 0 will keep it empty. Obviously, this can also be changed to some text. Just remember to add quotes for the text string: =IF(COUNTIF([Row_Name]41:[Row_Name]46, 1) = COUNT([Row_Name]41:[Row_Name]46), "Complete", "Still Working")

Auto Check Parent on any Child being Checked

Please share the formula for how to get the parent checkbox to show checked when any of its children are checked unlike the formula shared that they all have to be checked.

Re: Auto Check Parent on any Child being Checked

Kelly Anthony's picture
Hi Ben, Here's the formula you're looking for: =IF((COUNTIF(CHILDREN(), 1) > 0), 1, 0). Let us know if you have any other questions! Thanks, Kelly


Hi, Thanks so much for this formula! This is something I have been searching for quite some time. I had to use a special column before, to make it work. I am really happy to get rid of this column now.

Parent row Strike through & grayed out

I had the same question about arranging a formula that ensures the checkbox in the parent row becomes checked once all the children checkboxes are checked. Where do I put the formula? I tried the formula given in this post but nothing worked.. Andrew did this work for you? Help!

Re: Parent row Strike through & grayed out

Kelly Anthony's picture
Hi David, Here's the formula you'll need for the parent row: =IF(COUNT(CHILDREN()) = (COUNTIF(CHILDREN(), 1)), 1, 0) Let us know if you need any other help! Thanks, Kelly

Where do I place the formula?

Wow, that was a quick response! I'm very new to this, and no matter how many times I watch the USING FORMULAS video and play with the Formulas Smartsheet template, I still don't understand where to insert this formula? In addition, what info do I need to place into this formula and exactly where in the formula do is it that I need to place that info. Thank you very much! David

Re: Where do I place the formula?

Kelly Anthony's picture
Hi David, We'd love to help you out -- would you please send an email to us at Talk soon! Kelly

Count stars

Hi, I am trying to get a count of all stars in a column. I tried to adjust the RYG column formula that has been given in a post above, but it didn't work. The formula I put is is: ="Total Starred"COUNTIF([Job regarded as DEFECT as per ISM Code]:[Job regarded as DEFECT as per ISM Code], "star") What do I do wrong? Thanks! Heiko

Re: Count stars

Kelly Anthony's picture
Hi Heiko, Your formula is close, just a few small tweaks -- it should look like: =COUNTIF([Job regarded as DEFECT as per ISM Code]:[Job regarded as DEFECT as per ISM Code], 1) Feel free to send an email to if you're still running into challenges! Thanks, Kelly

Count checked boxes in a column

I'm trying the same kind of thing, counting all the items in column L10N that are checked. My formula is =COUNTIF(L10N:L10N, 1). I get the error #UNPARSEABLE. Thanks.

RE: Count checked boxes in a column

Smartsheet Community Manager's picture
Hi Joy, your error is a result of the number in the column header name, and you can circumvent this error by using brackets as follows: =COUNTIF([L10N]:[L10N], 1) Thanks! - The Smartsheet Team

Formula tools

I find the conditional formatting setup dialogue box very useful and intuitive. I use that tool to plot out my smartsheet formulas and find it pretty helpful.

Connecting a check box to percent complete column

I am trying to create a formula that when I check a box in my "Done" column it will automatically change the corresponding cell in my "Percent Complete" column to 100% and when it is unchecked "Percent Complete" would be 0%. I haven't found any formula that is similar to use as a guide. Do you know how I could create this?

Re: Connecting a check box to percent complete column

Hi Kim, You can use an IF formula in the rows of your percent complete column to accomplish this - here's an example of the formula you can use in row 6: =IF(Done6 = 1, 1, 0) Just make sure dependencies aren't enabled on the % complete column, otherwise it won't allow any formulas. Hope this helps!

It worked! Thanks!

It worked! Thanks!

Connecting a row of check boxes to a percent complete cell

Is there a way to connect multiple check boxes across a row to a percent complete cell? Just let me know, thanks.

Re: Connecting a row of check boxes to a percent complete cell

Kelly Anthony's picture
Hi Chris, As long as you don't have dependencies enabled in your sheet, you can use a nested if/and statement – if([one box is checked], [inset % number], if(and([two boxes are checked], [insert % number], etc. If you do have dependencies enabled (which is common in many project sheets), you won't be able to add a formula in the % complete column. If you have dependencies turned on, or if the formula above doesn't seem to work with your sheet, please email us at and we'll help you out! Thanks, Kelly

Check Boxes & Percent Complete

I have been struggling with this one too. I thought that I had it resolved but, I don't think so now. I wanted to be able to either click the "Done" checkbox and fill-in 100% in the Percent Complete cell automatically and if the user preferred they could enter 100% in the Percent Complete and have the Done checkbox checked automatically. I thought that I had it. Wrong! If you have the formula in either of these cells and the user enters something, you lose the formula. The only way I can think of to do this is to have the formula in a cell in a hidden dummy column and have that formula update the Percent Complete cell or the Done check box cell. I haven't been able to find anyone to tell me how I can do this. (Updating a cell with a formula in another cell).

RE: Check Boxes & Percent Complete

Smartsheet Community Manager's picture
Hi Jerry, As you mentioned, if you manually type in a cell with a formula, the formula will be deleted. We will suggest your requested feature of updating a cell with a formula in a different cell to our product team for consideration. Thanks! - The Smartsheet Team

Tick Box & Date

I have a column called complete which is a tick box. What I want to happen is when I tick that box it updates a date column with the day I ticked the box so that I can track when tasks were completed. Can you please advise on the correct formula to use?

Re: Tick Box & Date

Kelly Anthony's picture
Hi Simon, While there isn't a formula per say that would help, you may be able to add in a system column (, "Modified (Date)" to your sheet that will reflect the last time an update was made to your sheet. As long as the checking off the "complete" box is the last action performed on that row, you'll have a running account of when tasks are completed. If you make another update to that row, however, the system column will update automatically. Hope that helps! Best, Kelly

Checkbox to drive a Date

I'm looking for something similar to this... Once a checkbox is clicked, I'd like to display a date 3 business days from then. The Modified Date doesn't work for me, as we are updating other data in these same rows. Thinking something like "If Checkbox = True, then DateIs +3". Is anything like that available? THANKS!!

RE: Checkbox to drive a Date

Smartsheet Community Manager's picture
Christy - Unfortunately, the formulas don't currently lend to this function. You can have a formula that says "if the box is checked then show the date: today + 3," but "today" is relative and will change each day. The workaround we usually give is to use the modified date but it sounds like you know that and it will not work. We will submit an enhancement request to the product team for this, and we encourage all users with questions about functionality to participate at – Thank you!

Checkbox for date update

Hello Simon! You can also right click on the record, and select view history. It will enable a popup window, where you can track all the changes of that checkbox.

Percentage of Checkboxes Complete

Is there a way to calculate the percentage of checkboxes that have been checked out of the total, at the top of a single row.

Re: Percentage of Checkboxes Complete

Kelly Anthony's picture
Hi Craig, You can certainly use a formula for these calculations, although the formula will vary a bit depending on how your sheet is set up. If you're putting the formula in a parent row to find the percentage of child rows that are checked, here's the formula you'll use: ="" + ROUND((COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN())), 2) * 100 + "%". Please feel free to reach out to us at if you'd like more help. Thanks! Kelly

Not Count All Children

I have used the formula above to count how many check boxes, however I now need to insert another 'child' row, but do not want this to be counted. How can I just count 4 of the rows and not the 5th? Thanks!

Re: Not Count All Children

Kelly Anthony's picture
Hi Louise, If you're using the CHILDREN() calculation, any new rows added will be included in the total count as you described. You'll need to change the formula to reference a range, rather than using CHILDREN(). Feel free to contact us at for more help. Thanks, Kelly

Checkbox when a cell is 100%

Hi, I'm trying to do a formula that will check the box when a certain percentage is reached or when a cell is 100%. Is this possible? Thanks!

RE: Checkbox when a cell is 100%

Emily Esposito's picture
Hi Levi, yes that is possible. Use this formula, =IF([Percent Complete]3 = 1, 1), added to the checkbox cell. If you want it to check the box if its more than a certain percentage, use this formulas (example is if more than 75%): =IF([Percent Complete]11 > 0.75, 1). Best, Emily

Missing Parameters

Why do I keep getting missing parameters with this: ="COUNT: " + COUNTIF(CHILDREN(), 1) My row is titles Monday Night, I am trying to count different columns with check marks for how many are attending on different nights.

RE: Missing Parameters

Emily Esposito's picture
Hello -- we'd be happy to help! Please email us at and we can look into this further. Best, Emily

show ball as green if the box is checked

hi please help really need this formula. thanks!

RE: show ball as green if the ball is checked

Emily Esposito's picture
Hi Keith, here's an article with some steps on how to automate RYG balls: If you need any help, please email our Support team at support@smartsheet and we'd be happy to lend a hand. Best, Emily

sum with checked box

Hello, I'm trying to do a formula that will SUM values with checked box. It is possible?

RE: Sum with checked box

Emily Esposito's picture
Hi there -- Yes, you can use the SUMIF formula, which adds numbers within a range that meet a specific criteria. Visit this Help Center article,, and find the SUMIF section under "Advanced Formulas." Best, Emily


Please can you help me with a formula. I want to add a checkbox which checks if the 'Task Name' field contains the word "Email" Is this possible please and please can you supply the formula.

RE: Checkbox

Emily Esposito's picture
Hi Nick -- Here's the formula you can use: =IF(FIND("Email", [Task Name]1) > 0, 1, 0). Best, Emily

Check box reminder

I would like to set a reminder or alert to notify a user if a check box has been empty for two days. We are using smart sheets to track repairs and part of the process is evaluating the repair and I need for our repair guy to evaluate each one, I want to be able to remind him to do that if a repair stays un-evaluated for two days. Is there a way to do that? I can seem to figure it out by using the standard reminder and alert statements. Thanks J

RE: Check box reminder

Emily Esposito's picture
Hi Jody -- Unfortunately, this is not possible in Smartsheet today. However, I have passed this request along to our Product team for future consideration. Best, Emily

Un-check when date is past

I keep an Events list in Smartsheet. It was for internal use only, but now that I am Publishing Smartsheet Reports, I want to automate the updating of this report . I have added a "Publish" column with checkmark to be the "what" for a report. I would like to have Smartsheet automatically "un-check" any event that is in the past...however, I do not want the formula to automatically "check" all events in the future, as we have items on this list that we do not want to publish.

RE: Un-check when date is past

Emily Esposito's picture
Hi Bob -- We'd be happy to help! Please email our Support team at so we can build a formula that works for you. Best, Emily

Sum COUNTIF(children(),1) statements

I have several statements to sum the checkboxes for children. I have the cells linked to another sheet and would like to be able to sum the results. Is there a way to do this, or possibly a way to disable the checkbox in a single cell in a column?

RE: Sum COUNTIF(children(),1) statements

Emily Esposito's picture
Hi Steve -- To "disable" the checkbox, you could use a formula like ="Total: "+COUNTIF(Checkbox1:Checkbox785, 1). Feel free to email us at if you have more questions. Best, Emily

Formula Help

I am trying to set up a spreadsheet that has a list of names in column A, a check box in column B (training session 1) and also in Column C (training session 2). When either of the check boxes in columns B or C are checked I want the corresponding name from column A to be added to a list in a new sheet so that I can easily track who has replied and which training session they will be attending. I am not sure how to enter a formula to get the name to go to the list.


Add new comment