Add a specific condition to an existing formula

Hi,

I am trying to ad a specific condition

IF(TD<[@[DUE DATE]]+7,"PIPELINE"

to an existing formula. However, the existing condition

IF(TD<[@[DUE DATE]],"CURRENT"

is interfering with the addition, and I cannot figure out where I am going wrong. I tried all sort of combinations.

The complete formula is:

=IFERROR(IF(OR([@[INVOICE AMOUNT]]="",[@[INVOICE DATE]]="",[@[DUE DATE]]="",[@[DUE DATE]]<[@[INVOICE DATE]]),"ERROR",IF([@[OUTSTANDING AMOUNT]]=0,"PAID", IF([@[OUTSTANDING AMOUNT]]>0,IF(TD<[@[DUE DATE]],"CURRENT",IF(TD=[@[DUE DATE]],"DUE TODAY",IF(TD>[@[DUE DATE]],"PAST DUE"))),IF([@[OUTSTANDING AMOUNT]]<0,"OVERPAID")))),"")

I'd appreciate your input and help in this matter.

Thank you :)

Marion

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!