Sign in to join the conversation:
Hi there,
I'd like to use an =IF formula to identify those cells where the checkbox is ticked - does anyone know what syntax should be used to identify a ticked checkbox, i.e. =IF(cell = ????,1,0) (where ???? = ticked checkbox)?
Thanks,
Paul
1 and 0
if([This column]1=1,"true","false") will post true when the checkbox is checked.
if([This Column]1=0,"true","false") will post true when the checkbox is unchecked.
=IF([Checkbox Column Name]# = 1, Result if Checked, Result if Unchecked)
If you give more specifics or a screenshot I can assist you with your formula.
There are a couple of things that raise questions that might be good for us to know before we can truly help you. You asked about identifying a checkbox... are you trying to flag the row with a checkbox? If so, then the formulas these others are offering you make sense. But my initial thoughts are, doesn't the tick-box being ticked identify it as being ticked?
Have you considered conditional formatting to highlight all the rows? Are you trying to list out the main column of every row that has a tick box? Your request could be better answered with some greater clarification.
Hi Paul,
I'd recommend checking out our help articles for details on formula creation: https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet
...and our complete functions list: https://help.smartsheet.com/functions
You can see an example of the IF statement here: https://help.smartsheet.com/function/if
Thanks everyone. Problem has been solved as per Luke's reply.
Best regards,
Thanks Luke. This has solved my problem.
Thank you this helped!
Awesome. I'm glad our corporate knowledge has helped you out!
Date Report Partner CBO Name 01/12/25 Children's org 05/15/25 Foodbank 08/30/25 Children's org 09/11/25 Chamber 11/25/25 Digital Bus 08/21/24 Digital Bus South 01/15/26 Children's org 01/12/24 Foodbank Sister 02/15/24 For the children org 07/01/26 Digital Bus #2 08/05/26 Family Center 12/01/26 Family Center I am trying to…
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
