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!
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.
Hi all, I'm having some issues with an index-collect formula. I have (3) existing sheets that list a unique project name (text field), as well as a producer assigned to work that project. The producer column in all (3) sheets is set as a contact field. In a separate sheet, I'm trying to auto-populate the producer…
I am currently in business trial version, but i was told it is supposed to allow for full functionality, however when I click Ctr+F my search menu is only a search bar that allows me to only find the string, and it doesn't allow for replacing. Is it me or the F&R functionality rather limited?
