Can I auto-set a column value to โRejectedโ if one of the other column value exceeded more than โ3โ
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:
User | Count |
---|---|
42 | |
30 | |
25 | |
23 | |
13 |