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!
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])
I'm not able to "view by" a field that I have in my sheets - Quarters (Q1, Q2, Q3, Q4) - in my report. I think it is because I have used a formula to calculate the quarters in my sheets. Does anyone know a way to get a formula based field on the dropdown for view by in my report?
=SUMIFS({GM Compliance Trained}, {GM Compliance Training Dept}, Department@row , {Compliance Training Date}, MONTH(7, 8, 9)) GM Compliance Trained is the number of employees trained. I am trying to sum the number of employees trained in each department during 3rd quarter (July 1-Sep 30). Thinking I need an IFERROR in there…