Hi @HZAR

Please try the following formula:

=IF([Buyer Status]@row = "cancel", "Not Required", IF([xx Proposed Settlement ($USD)]@row >= {Buyer Supervisor Limit}, "YES", IF([xx Proposed Settlement ($USD)]@row = "", "TBD", "NO")))

This formula works as follows:

1. It first checks if the Buyer Status for the current row is "cancel." If it is, the formula immediately returns "Not Required."
2. If the Buyer Status is not "cancel," it then checks if the [xx Proposed Settlement ($USD)] value meets or exceeds the {Buyer Supervisor Limit}. If it does, it returns "YES."
3. If the [xx Proposed Settlement ($USD)] value does not meet the threshold, it checks whether this value is empty (""). If it's empty, it returns "TBD."
4. If none of the above conditions are met, it returns "NO."

Make sure to replace [Buyer Status] with the actual column name in your Smartsheet where the buyer status is recorded. This formula assumes that the buyer status that triggers "Not Required" is specifically "cancel" and is case-sensitive. If there are variations in how "cancel" is recorded (like "Cancelled" or "canceled"), you'll need to adjust the condition to account for these variations.

You are welcome @HZAR