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"
)
4 Likes
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.
2 Likes
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?
2 Likes
@vinson_Mirdif_Securi
And once again this brings us to a position to read this post well deserved:
2 Likes