Set Auto Value

Can I auto-set a column value to “Rejected” if one of the other column value exceeded more than “3”

0 6 299
6 REPLIES 6

LeventK
Participant V

Sure thing. Set an AppFormula for the required column.

IF(
    [One_of_the_other_Column] > 3,
    "Rejected",
    "Value_if_not_exceeded_3"
)

Provided you like to check if the difference between the edited and changed value of a certain column and the previous value is greater than 3, then the expression shall be:

IF(
    ([One_of_the_other_Column] - LOOKUP([_THISROW].[KeyColumn],"TableName","KeyColumnName","One_of_the_other_Column")) > 3,
    "Rejected",
    "Value_if_not_exceeded_3"
)

it’s not working, I will explain again here

I want to set the value as ‘Rejected’ in the column [Column A] if [Column b]'s value is more than 3

column A type is (Enum)
column B type is (Text)

Hello @vinson_Mirdif_Securi, i believe your column type for the column B should be number or decimal, and not text.

The problem if I using this formula is I am not able to use other Action (for changing same column status), I attached a screenshot here

This error indicates one of the following possibilities:

  • The Status column is the key column.

  • The key column is a computed key, and the Status column is used to compute the key.

  • The Editable? setting for the Status column is set to OFF.

  • The Status column has an App formula expression.

  • The Status column is a virtual column.

Which is it?

@vinson_Mirdif_Securi
And once again this brings us to a position to read this post well deserved:

Top Labels in this Space