Reset on Edit not resetting to initial value

[Daisy_Ramirez]

I’ve configured a field (BIN Barcode) to Reset on Edit by using a Change Time Stamp field that looks for changes in 2 specific fields (Barcode Flag and Metal BC Flag).

When there’s any change in either of the two fields, I’d like the BIN Barcode field to Reset to the fields Initial Value. It seems to work fine, until an entry is made directly into the BIN Barcode field or the calculated value is adjusted. Once this is done the field no longer Resets.

Here is the Initial Value expression:
IFS(
OR([Metal BC Flag]=Y,[Barcode Flag]=Y)," ",
AND([Barcode Flag]=“N”,NOT(ISBLANK([vir_site_id]))),
IFS(
AND([Barcode Flag]=“N”,LEN([vir_site_id])=5),“00000”&[vir_site_id],
AND([Barcode Flag]=“N”,LEN([vir_site_id])=4),“000000”&[vir_site_id],
AND([Barcode Flag]=“N”,LEN([vir_site_id])=3),“0000000”&[vir_site_id],
AND([Barcode Flag]=“N”,LEN([vir_site_id])=2),“00000000”&[vir_site_id],
AND([Barcode Flag]=“N”,LEN([vir_site_id])=1),“000000000”&[vir_site_id]
),
AND([Barcode Flag]=“N”,ISBLANK([vir_site_id])),
“5555555555”
)

Is there any way to make the BIN Barcode field Reset to blank every time the Barcode Flag and Metal BC Flag is set to Y? The use case is when a user inputs the BIN Barcode and then changes their mind and updates the Barcode Flag or Metal Barcode Flag.