This formula is producing syntax error when I try to make the column a "column formula". Is there a workaround? As we add new Rows (copied from different sheet), I want all values in Client Name column to equal Task column Row 1.