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 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?

[Aurelien]

Hi @Francisco1988 

You may want to check this option, in your column properties (black pen):

[Francisco1988]

Hi! It's already marked. The problem occurs when editing a form already filled in, the Start Date and End Date fields no longer change according to the Request Date field

[Aurelien]

Oh, I misunderstood your question, my mistake. 

It won't change once it's edited or you type it.

If the columns [Start Date] and [End Date] have this option checked, this is weird that initial value won't calculate again.

Is it possible to set the "request date" in first position ?

[Francisco1988]

Exactly. It will not change after being edited or typed. I think this is due to the ISBLANK([_THIS]) Because in this case it will only change when the field is blank. How do I change it if it's already filled in too?

[Aurelien]

I'm not sure what your purpose is with the ISBLANK([_THIS]), but what if you try something like this ?

OR(
  ISBLANK([_THIS]),
  yourOtherCondition
)

[Francisco1988]

i tried it OR( ISNOTBLANK([_THIS]), ISBLANK([_THIS]) ) The problem is when I select "Entrgue" in the Request Date field, the value saved in the Finish Date is erased. The same occurs when I enter "In progress" in the Request Date field, the value saved in the Start Date is deleted. I need the values ​​to remain in each field regardless of the change made in the Request Date field

[Aurelien]

This:

OR( ISNOTBLANK([_THIS]), ISBLANK([_THIS]) ) 

should be removed, as you are saying "whether it is blank or not".

I'm afraid I don't get the scenario you have in mind, sorry for that.

If your condition depends on various cases, you may want to use a combination of IF(), AND(), OR(), ISBLANK(), as described here:

https://support.google.com/appsheet/answer/10107398?hl=en

https://support.google.com/appsheet/answer/10108121?hl=en&ref_topic=10104782

https://support.google.com/appsheet/answer/10107337?hl=en&ref_topic=10104782