Incorrect Argument Set

Sarah Thompson · 07/17/19

Hi All,

Trying to figure out why I'm getting the Incorrect Argument Set with the following formula. Works fine with most rows, but gives the incorrect argument set when the Date Requested By School is less than or equal to 14. I tried adding that in to one of those rows, thinking it was missing a component, and still got the error. Anybody have any ideas? I'm having a brain fart. Here's the formula:

IF(ISTEXT([Airline Contract Attached to Row]@row), "No Pain", IF(Suggested@row = 1, "No Pain", IF(Cancel@row = 1, "No Pain", IF(ISDATE([Cancelled Space with Airline]@row, "No Pain", IF(TODAY() - [Date Requested by School]@row > 14, "Extreme"))))))

Thanks-

Sarah

Andrée Starå · 07/18/19

Hi Sarah,

There were a few errors with the placement of/and missing parenthesis.

Try something like this.

=IF(ISTEXT([Airline Contract Attached to Row]@row); "No Pain"; IF(Suggested@row = 1; "No Pain"; IF(Cancel@row = 1; "No Pain"; IF(ISDATE([Cancelled Space with Airline]@row); "No Pain"; IF(TODAY() ([Date Requested by School]@row) > 14; "Extreme")))))

The same version but with the below changes for your and others convenience.

=IF(ISTEXT([Airline Contract Attached to Row]@row), "No Pain", IF(Suggested@row = 1, "No Pain", IF(Cancel@row = 1, "No Pain", IF(ISDATE([Cancelled Space with Airline]@row), "No Pain", IF(TODAY() ([Date Requested by School]@row) > 14, "Extreme")))))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Incorrect Argument Set

Comments

Categories