Welcome!

auto tick box checked dependent on all dots green

Hi I have several columns when once all green dots turns the row green, done with conditional formatting, however I have a column with a check box and want a formula that automatically ticks the checkbox once all dots in row are green, please can someone help?

Find more posts tagged with

Comments

Ofir Marco

I think you are looking for a formula like this in your checkbox column:

=IF(AND([Ind #1]1 = "Green", [Ind #2]1 = "Green", [Ind #3]1 = "Green"), 1, 0)

Is that what you are trying to achieve (see screen shot below)?

rob.begley

Thank you

That' exactley what was looking for, I ended up meeting some if functions and using a ball to show green instead of a check box

I will have a play tomorrow as I would prefer the check box

Many thanks

Rob

Ofir Marco

Your'e welcome.

Let me know if you need help during the process.

Sign in to join the conversation!

Quick Links

Trending discussions

Template Downloads
Hi, I've watched number of training videos, specifically to set up PMO. I followed the instructions to download a template set, but it always adds it to a workspace, not the sheets folder. In fact if i download anything it adds it to a workspace, not sheets folder. What am I doing wrong?
Switching Rows and Columns for Reports
I have a sheet that has about 90 columns, but it might only have 12 rows. It would be easier to review reports if I could flip the columns/rows on the report and/or dashboard. Is there any way to do this? Even something using other views.
What are the options for handling a 60-item questionnaire with 8 nested child questionnaires?
Hello everyone, Initially, I was assigned to work on a 37-item questionnaire (form) that included 6 nested child questionnaires, resulting in a total of 222 columns. However, as the questionnaire has expanded, the number of items has grown significantly and is now approaching Smartsheet’s column limit. Considering that we…