Helper columns, status values and score bands — how to structure a sheet so conditions stay readable after a thousand rows.
Prefer a small set of explicit status values over free text. Approved, Pending and Rejected are conditionable; notes are not.
Add a helper column when a condition needs maths
Compute the band once in the sheet, then condition on the band.
One row per person per workflow
Keep one row per person per workflow. Duplicate protection works best when a row means one decision.