Problem Condition IF

[Francisco1988]

Case:
In my form I have a problem in 3 fields Start Date, End Date and Request Status. 
In the Start Date and End Date fields, there are the following formulas:

Initial Value formula for column Start Date (Date)
IF([Request Status] = In Progress, TODAY(), "")
Initial Value formula for column Data Termination (Date)
IF([Request Status] = Delivered, TODAY(), "")

The Start Date and End Date fields depend on the current state of the Request Status field. 
The Request Status field is of type Enum and contains the following values: “In Progress”, “Delivered”, “To Deliver”.

Problem:
When changing the Request Status field to “Delivered” if the Start Date is filled in, 
the value contained in this field is deleted. The same happens when changing 
the Request Status field to “In Progress”, the value contained in the 
“Termino” field is deleted. It also occurs when changing the 
Request Status field to “To Deliver” values ​​contained in the Start Date and End Date fields are deleted.
I need that once the value entered in the Start Date and End Date fields is no longer changed

[Marc_Dillon]

Sounds like you're using ResetOnEdit, right? You can write an expression to only reset under certain circumstances, like if the column ISBLANK().

[Francisco1988]

Yes I am using ResetOnEdit.

Could you detail what this expression would look like with ISBLANK()?

[Marc_Dillon]

Probably just ISBLANK( [_THIS] ) would work.

[Francisco1988]

I changed the formula in the fields as per your suggestion 

Initial Value formula for column Start Date (Date)
IF(ISBLANK([Status da Solicitacao]) = Em Andamento, TODAY(), "")

Initial Value formula for column Data Termination (Date)
IF(ISBLANK([Status da Solicitacao]) = Entregue, TODAY(), "")

the fields remained blank. What did I do wrong?

[Marc_Dillon]

Oh, no, your original Initial Values expressions were fine. The ISBLANK( [_THIS] ) is to put in as an expression for the ResetOnEdit. Just like a SHOW? or EDIT? toggle, you can also put an expression into it from the flask icon.

[Francisco1988]

Marc, a doubt. The form allows editing the Start Date and End Date fields by the Request Date field only in the first insert of the form.
If you need an update on the form in the Start Date and End Date fields, it is necessary to edit them manually. How do I make this edit continue automatically?
through the Request Date field?

[Marc_Dillon]

Sorry, I don't understand any of that last message.

[Francisco1988]

Following your previous email request to insert ISBLANK( [_THIS] ) is to put in as an expression for the ResetOnEdit, The form allows editing the Start Date and End Date fields by the Request Date field only in the first insert of the form .
If you need an update on the form in the Start Date and End Date fields, it is necessary to edit them manually. How do I make this edit continue automatically?
through the Request Date field?

[Marc_Dillon]

Copying and pasting the same thing, that I didn't understand in the first place, doesn't help. I have no idea what "by the Request Date field" means, and I don't know what you're asking.

[Francisco1988 · Accepted solution]

Case:
In my form I have a problem in 3 fields Start Date, End Date and Request Status.
In the Start Data and Term Data fields, there are the following formulas:

Starting value formula for a starting data column (date)
IF([Request Status] = In Progress, TODAY(), "")
Initial value formula for a Data Term (Data) column
IF([Request Status] = Delivered, TODAY(), "")

The Start Date and End Date fields of the Request Status field's current state.
The Request Status field is of type Enum and contains the following values: “In Progress”, “Delivered”, “To Deliver”.

No Reset field in built-in edit
ISBLANK([_THIS])

Problem:
Allows you to edit the Start and End Date fields by the Request Date field only on the first form insertion.
In case of updating the form in the Start Date and End Date fields, it is necessary to edit them manually.
How do I make this edit automatically continue on the Request Date field?