Initial value of blank

Hi,
I wonder if you can set a column to reset to it’s initial value of blank, so basically when another column’s value matches the formula then the cell is reset to be empty.?

Thanks in advance,
Chris

Just off the top of my head - If the column you want to set to blank is an calculated column and you can accept that blank is the same as “”, then a formula could do this. If the column you want to be blank is not calculated (user filled), the. You might have to create an action to do this (overwrite current value).

Think the creating an action route may be best, will give it a shot…

Thanks very much.
Chris

@Chris_Jeal
Concur with @Mike here. You can set an initial value with IFS:

IFS(
[ColumnA]="SomeValue","Show This",
TRUE,CONCATENATE("")
)

If you also set that this column value is resetted with every edit, the IFS expression will be re-evaluated on each edit.

1 Like

@LeventK’s IFS() is equivalent to:

IF(
[ColumnA]="SomeValue","Show This",
""
)

or:

IFS(
[ColumnA]="SomeValue","Show This"
)

Ok,
So I have managed to get the desired result by creating behaviors for all of the actions I needed completing.

I created 3 separate behaviors and then one to complete these 3.

Sometimes, the simple answers are the most effective.

Thanks chaps for your help and suggestions, got there in the end.

Chris.

@Chris_Jeal - glad you were able to solve it! Keeping it simple is good.

@LeventK - love the idea of considering “reset on edit”. Will have to explore more use cases for that new feature.