Problem with returning a value when a cell is blank

Hello - The first half of the formula below seems to work fine. However i need to return a value if ([Opportunity End Date]@row) is not blank.

I'm either receiving #unparsable or #incorrect argument. If you could help, would be greatly appreciated.

=IF(ISBLANK([Opportunity End Date]@row), TODAY() - ([Opportunity Creation Date]@row), IF(ISDATE([Opportunity End Date]@row), ([Opportunity End Date]@row - [Opportunity Creation Date]@row))))

Find more posts tagged with

Accepted answers

julieg

Problem solved. Opportunity End Date was a text field, not a date field. Now the formula works fine.

All comments

Paul Newcome

You are using too many parenthesis. Try this...

=IF(ISBLANK([Opportunity End Date]@row), TODAY() - [Opportunity Creation Date]@row, IF(ISDATE([Opportunity End Date]@row), [Opportunity End Date]@row - [Opportunity Creation Date]@row))

Another option would be to just leverage the third portion (value if false) of the first IF to say that if the ISBLANK function is not true, output "xyz".

=IF(ISBLANK([Opportunity End Date]@row), TODAY() - [Opportunity Creation Date]@row, [Opportunity End Date]@row - [Opportunity Creation Date]@row)

julieg

Problem solved. Opportunity End Date was a text field, not a date field. Now the formula works fine.

julieg

You are correct Paul, I had too many paranthesis. Thank you for your prompt response.

Paul Newcome

Happy to help. 👍️

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.