Incorrect Argument Set

Options
✭✭✭✭

Hi All,

I have a formula that worked in one row, but then when I make it a column formula, it shows "incorrect argument set" in all the other rows but the 1st one. Please see below:

That's the formula:

=IF(AND([CLIENT TYPE]@row = "Platinum", [TOTAL AGING]@row > 1), "Red", IF(AND([CLIENT TYPE]@row = "Gold", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Not Started"), "Red", IF(AND([CLIENT TYPE]@row = "Gold", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Review"), "Yellow"), IF(AND([CLIENT TYPE]@row = "Silver", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Not Started"), "Yellow"), IF(AND([CLIENT TYPE]@row = "Silver", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Review"), "Yellow", "Green")))

• ✭✭✭✭✭✭
Options

Can you try the formula below?

```=IF(AND([CLIENT TYPE]@row = "Platinum", [TOTAL AGING]@row > 1), "Red", IF(AND([CLIENT TYPE]@row = "Gold", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Not Started"), "Red", IF(AND([CLIENT TYPE]@row = "Gold", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Review"), "Yellow", IF(AND([CLIENT TYPE]@row = "Silver", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Not Started"), "Yellow", IF(AND([CLIENT TYPE]@row = "Silver", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Review"), "Yellow", "Green")))))
```

Best Regards

Smartsheet CoE, Ignatiuz Software, Exton, PA

• ✭✭✭✭✭✭
Options

Can you try the formula below?

```=IF(AND([CLIENT TYPE]@row = "Platinum", [TOTAL AGING]@row > 1), "Red", IF(AND([CLIENT TYPE]@row = "Gold", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Not Started"), "Red", IF(AND([CLIENT TYPE]@row = "Gold", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Review"), "Yellow", IF(AND([CLIENT TYPE]@row = "Silver", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Not Started"), "Yellow", IF(AND([CLIENT TYPE]@row = "Silver", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Review"), "Yellow", "Green")))))
```

Best Regards

Smartsheet CoE, Ignatiuz Software, Exton, PA