How to clear a column base on a true or false selection in another column

AppSheet AppSheet Q&A
1

Does anyone know a formula to clear a column selection base on a true or false answer on another colunm.

I have a column that only shows up if another column is true. When the column shows up I can choose a number from 1 - 5. If I go back and select false in the other column, i want the selection from 1-5 to be clear.

2

Hi @casitasrd

I suggest you use an action, in order to reset your columns informations.
This will be with a grouped action:

  • Action 1 : set columnA to false
  • Action 2 : set ColumnB to “” (i.e. clear)
  • Action 3 : grouped action : Action1 + Action 2

Let us know if that works for you

1 Like
3

The difficulty here is that you can automatically choose a value for the second column based on the first column, but once the user manually changes the value of the second column, automatic changes to the second column will no longer occur.

It appears your second column could make use of a dropdown input using Valid If. If so, you could take advantage of its behavior to change the dropdown choices according to the value of the first column. If the first column value is changed to false, Valid If can declare no valid choices, and the existing choice will be removed.

IF(
  (FALSE <> [first-column])
  LIST(1, 2, 3, 4, 5),
  LIST()
)

See also:

2 Likes
4

This seems like could work Steve. Let me give it a try.

1 Like
5

@Steve it worked. You’re the man!
The only thing was missing is a comma.

IF(
(FALSE <> [first-column]),
LIST(1, 2, 3, 4, 5),
LIST()
)

Thank you sir!

3 Likes
6

casitasrd:

The only thing was missing is a comma.

Whoops!