I want to use a Checkbox column that would indicate whether several items in a row have been completed and if all are done (those items have check boxes showing completion), then the Checkbox column would get checked automatically.
Try using an IF(AND statement such as
=IF(AND([First Checkbox]@row = 1, [Second Checkbox]@row = 1, [Third Checkbox]@row = 1), 1)
I want the "Organizational Charts" and other rows to be marked "Completed" with the check box when all of the contributing items are checked.
Yep, that's exact;y what I needed - Thank you. I was trying to do it with a range like we do with columns.
You can use a range like you do with a column but ONLY IF all of the checkboxes are right next to each other with no interruptions.
To count how many are checked:
=COUNTIFS([First Check Column]@row:[Last Check Column]@row, 1)
To count how many are supposed to be checked (or you could just manually enter a number if you don't plan on adding or removing the columns):
=COUNTIFS([First Check Column]@row:[Last Check Column]@row, OR(@cell = 1, @cell <> 1))
Comparing the two in an IF statement that says if they both match (meaning all are checked:
=IF(COUNTIFS([First Check Column]@row:[Last Check Column]@row, 1) = COUNTIFS([First Check Column]@row:[Last Check Column]@row, OR(@cell = 1, @cell <> 1)), 1)
Or if you don't plan on changing the number of columns that need checked (using your above screenshot):
=IF(COUNTIFS([First Check Column]@row:[Last Check Column]@row, 1) = 6, 1)
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello. Trying to make a quick attendance tracker for a meeting. I got conditional formatting to change the cell color when its checked vs unchecked. However I cannot seem to find a way to get the rule to apply to multiple columns on a per column basis. I need a way to copy what I have for column 3 and apply it to all…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.