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?
And once again this brings us to a position to read this post well deserved: