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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!