Stuck on IF formula

Heather Szukis · 02/01/22

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 · 02/02/22

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 · 02/02/22

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 · 02/02/22

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

thank you it worked!!!!!

Stuck on IF formula

Answers

Help Article Resources

Categories