Early or Late for finish date based on Due date

I have to be closed. I am comparing finish date is equal or less to due date "OnTime" if finish date is after due date, "late".

I'm first making sure the finish date is populated.

=IF([Finish Date]@row <> "", IF([Due Date]@row < [Finish Date]@row , "On Time", "Late",), " ")

Please let me know what I may have done wrong in this formula.

Thank you
Mar

Find more posts tagged with

Accepted answers

Andrée Starå

https://community.smartsheet.com/discussion/comment/491260#Comment_491260

Excellent!

Happy to help!

✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

All comments

Andrée Starå

https://community.smartsheet.com/discussion/141437/early-or-late-for-finish-date-based-on-due-date

Hi,

I hope you're well and safe!

Try something like this.

=IF([Finish Date]@row <> "", IF([Due Date]@row < [Finish Date]@row , "On Time", "Late"))

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

Mar44

Andre'e

Thank you for responding. Oh my gosh! It was the data type. The finish date was not of date type. Both our formulas worked. I went with your because of your assistance.

Thank you

Mar

Andrée Starå

https://community.smartsheet.com/discussion/comment/491260#Comment_491260

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.