Stuck on IF formula

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.

Find more posts tagged with

Accepted answers

All comments

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!!!!!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.