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!
Smartsheet Community - I AM STUMPED!! I am trying to do a crosssheet SUMIFS formula with 1 Column and 2 Rows of Data. I need to sum across {Weeks 1 to 104} Column to match : {Helper Column} = Baseline@row Vertical Rows {Month} needs to match Month@row, and Row {Year} needs to match Year@row I have tried SUMIFS, JOIN,…
Hello I am looking to create a Smartsheet formula that returns the following result: Column A "Created Date" - this column type is a Created date and show results with date and time Column B "Received Date" - this column would round up the "Created Date" and just show date, no time. If the "Created Date" was after 2:00pm…
Cant figure out why this is not working. It comes back NO MATCH. I have changed it to true and to 1. Nothing works. HELP
