Stuck on IF formula

Heather Szukis

Hello, please help I know this fix is simple. I need training status column to either reflect Complete, Past Due or Outstanding. I left a copy of a formula I started messing with and and am just stuck.

If Completion Date is blank then training status should be Outstanding

If Completion Date is greater than general training due date, then training status should be Past Due

If Completion Date is less than general training due date, then training status should be Complete.

Sameer Karkhanis

Try below,

IF(ISBLANK([Completion Date]@row), "OUTSTANDING",
	IF(ISBLANK([General Training Due Date]@row),"SPECIFY TRAINING DUE DATE FIRST",
		IF([Completion Date@row] > [General Training Due Date]@row, "PAST DUE", "COMPLETED")
	)
)

Amy.Mizzi

You were getting there! Try this:

=IF([Completion Date]@row = "", "", IF([Completion Date]@row > [General Training Due Date]@row, "Past Due", IF([Completion Date]@row <= [General Training Due Date]@row, "Complete")))

Heather Szukis

https://community.smartsheet.com/discussion/comment/318247#Comment_318247

thank you it worked!!!!!