Formula Question

Hello community, I cannot figure out why this formula is #UNPARSEABLE in Smartsheet when it works perfectly in Excel. The intent is to show the amount of days left before/after "Due Date" [Column5].

EXCEL

=IF(E2="","",IF(E2<TODAY(),-DATEDIF(E2,TODAY(),"d"),DATEDIF(TODAY(),E2,"d")))

SMARTSHEET

=IF([Column5]2="","",IF([Column5]2<TODAY(),-DATEDIF([Column5]2,TODAY(),"d"),DATEDIF(TODAY(),[Column5]2,"d")))

Help please!!!

Find more posts tagged with

Formulas

Importing and Exporting

Accepted answers

All comments

David Tutwiler

I believe this is the same as another question you put in. I will just copy the answer from there:

I think you're making the formula too complicated for what you're looking for. If you just want days before/after you should be able to do

=[Column5]@row - TODAY()

Carlos Gonzalez

Hi David,

Sorry about the multiple posts, it kept coming back with a failure to post message. Anyway, that worked beautifully. Thank you for the help. Have a great weekend.

David Tutwiler

Great news! You do the same.

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.