Formula and Editable at the same time

[Shaun_Stringer]

Is there a way to make this happen in a form?

IF(Condition 1, then Result 1, otherwise Column is Editable)?

[SkrOYC]

Try:

AppFormula

IF(
  FALSE,
  "Something",
  ""
)

Editable_If

[_THIS]=""

[Josh_Klassen]

Yes but what is your condition?

[Shaun_Stringer]

Goal is....

Formula in column 2 = IFS([Column 1] < 2, "")

EditableIf in column 2 = [Column 1] > 1

[Shaun_Stringer]

No, it did not work. It gave me this message: "Column Name 'Column 1' in Schema 'App Name_Schema' cannot use an EditableIf constraint if it has an App Formula. The EditableIf constraint will be ignored."

I also tried...

AppFormula

IFS(

   Condition,

   ""

)

Editable_If

[_THIS] = ""

This displayed the column I wanted to edit if the condition was true but it was not editable.

[Srikanth_S]

Go to the table, columns

Select the column, in the initial value type:

If condition met, value1 else "".

Go editable and your condition 

If condition not meet, shall be editable other wise not. 

Regards

[Shaun_Stringer]

unfortunately, "value 1" is a choice from a referenced list, so I cannot state what it would be. I also cannot assume an initial value, see below.

Another way of stating what I am trying to do -

1. If Column 1 is 1, Column 2 is blank
2. If Column 1 is > 1, Column 2 is a choice from a referenced list
3. If the user completes number 2. (above), THEN goes back and changes Column 1 to < 2,

I want to automatically reset the value of column 2 to blank.

Sorry if my poor explanations don't make much sense...

[SkrOYC]

Yes, I'm sorry. I even wrote "AppFormula" without realizing how wrong it was.

AppFormulas make a field uneditable ipso facto.

I think you want an Initial Value instead.

If you don't, you may want to have an Initial Value with reset on edit

[Shaun_Stringer]

Another way of stating what I am trying to do -

1. If Column 1 is 1, Column 2 is blank
2. If Column 1 is > 1, Column 2 is a choice from a referenced list
3. If the user completes number 2. (above), THEN goes back and changes Column 1 to < 2,

I want to automatically reset the value of column 2 to blank. Basically trying to eliminate a forward reference issue to make Valid_If statements easier on the user.

[Steve · Accepted solution]

Your condition (3) is not possible: once the user modifies the column value, there is no way to change the column value automatically until after the user saves the form.

[Shaun_Stringer]

Any word about this becoming a possibility in the future?

[Steve]

I'm unaware of any plans to change the current behavior.