Empty value if other column isnotblank

[Ksenia1]

Is it possible to empty the value of my (ref) column if the column after is being filled?

My "Material" column has a valid if formula:

ISBLANK([Material_man])

but instead I want the chosen value in "Material" to be emptied if the user filled the column "Material_man".

[Marc_Dillon]

Run a form save action to clear up any values that need to be cleared.

[Ksenia1]

Thanks @Marc_Dillon. I hope, I got it right, but will it empty the column BEFORE saving the form? So immediately after the user writes something in "Material_man", the previously selected column "Material" shall be emptied.

[Marc_Dillon]

---

@Ksenia1 wrote:

but will it empty the column BEFORE saving the form? So immediately after the user writes something in "Material_man", the previously selected column "Material" shall be emptied

---

No.

[WillowMobileSys · Accepted solution]

Hi @Ksenia1 !

@Marc_Dillon  is correct.  In a NEW row entry, once a user has chosen a value, there is no way to automatically "reset" that column.   You can use validation, as you have shown and maybe customize the message stating something like "Material cannot be selected if Material Man is filled in". 

OR...if the "Material Man" column IS filled in, hide the Material column and then, as @Marc_Dillon  suggested, use an action to clear the Material column after Save.

It might also be helpful to the user if you swapped the column order, since users tend to fill out the Form top down.  

If you are trying to solve this while EDITING and existing row, then you can turn on "Reset on Edit" and use an Initial value expression in the Material column like this:

IF(ISNOTBLANK([Material Man]), "", [_THIS])

[Ksenia1]

Thank you @Marc_Dillon and @WillowMobileSys