Automatically setting one column to blanks when another column changes

[Jeff_Gordon]

I’m a novice user so I’m not sure yet how the pieces of AppSheet fit together. But here’s what I’m trying to accomplish …

I have these fields:

• [Priority] is text.
• [List] is text.
• [Done] is text.
• [When] is text.
• [Hide Until] is a date field.

Note that the above text fields get manually entered and changed EXCEPT when I want to automatically blank out those text fields when [Hide Until] > it’s previous value. For example:

Before editing:

• [Priority] = “Urgent”
• [List] = “AAA”
• [Done] = “Done”
• [When] = “This Week”
• [Hide Until] = 8/3/2020

I edit [Hide Until] to be 8/4/2020 (any value > 8/3/2020)

When I save it, I want the end result to be:

• [Priority] = “”
• [List] = “”
• [Done] = “”
• [When] = “”
• [Hide Until] = 8/4/2020

What I’ve tried:
I tried a behavior to “Set these columns” to “”
and “Only if this condition is true” … [Hide Until] > [_THISROW].[Hide Until]
but that doesn’t seem to do anything.

Any ideas on what the proper approach should be?