Problem with returning a value when a cell is blank

julieg

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

julieg

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

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. 👍️