Help with dropdown for Q&A

[Gideon_Lahav_Busines]

I want that when a user presses a checkbox it will make all the rest false.

גדעון להב

Thank you (

[Uzo]

use the custom check list

[Gideon_Lahav_Busines]

How and where is it?

[Uzo]

here it is… SAMPLE

[Gideon_Lahav_Busines]

I entered but did not see it…

Is it CSS?

[Uzo]

no, just math and if else columns
click link again… i updated it

[Gideon_Lahav_Busines]

Can you explain me the logic…

Q1

If Q1 true then true, eles false?

Q2
Q3

Would love a screen shot

[Uzo]

you need to base your check on timestamp, then pull the latest one with rollup column, that’s how you will know which option is checked… then simple if-else column to assign value to that row

[Gideon_Lahav_Busines]

This is just WONDERFUL !!

[Uzo]

this is very simple but so powerful solution for many problems

[Jeff_Hager]

Here are a few more similar examples.

Reset Multiple Rows At Once

There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n…