Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formula error in Nested IF Loop

edited 12/09/19 in Archived 2017 Posts

Hi SS Community,

Trying to automate shipment status using 'date needed by' and 'expected delivery date', but currently have an error with nested if loop #INCORRECT ARGUMENT SET,

=IF([Date Needed by]1 < [Expected Delivery Date (Purchasing Agent)]1, "LATE", IF([Date Needed by]1 >= [Expected Delivery Date (Purchasing Agent)]1, "On-Time"), " ")

The last " " is present so that the formula wont iterate to ontime on each cell while copy pasting.

Any help would be great, Thanks!



This discussion has been closed.