Help with # of days Formula. Returning "#UNPARSEABLE" Error

miaha

I am trying to calculate the number of days between two date columns in my Smartsheet: "Date" and "Date Closed". If "Date Closed" is blank (indicating the issue is still open), I want to calculate the number of days from "Date" to the current date. Here is the formula I am using:

=IF(ISBLANK([Date Closed]@row), TODAY() - [Date]@row, DATEDIF([Date]@row, [Date Closed]@row, "D"))

However, I am getting the "#UNPARSEABLE" error in the "Days" column. Here are some details about my setup:

• Both "Date" and "Date Closed" columns are formatted as Date type.
• Some cells in the "Date Closed" column are blank because the issues are still open.

Could someone please help me understand why this formula is returning "#UNPARSEABLE" and how I can fix it?

Thank you!

miaha

Hi all, I have solved my issue. This is the formula I got in case anyone needs it.

=IF(ISBLANK([Date Closed]@row), TODAY() - Date@row, [Date Closed]@row - Date@row)

miaha

Hi all, I have solved my issue. This is the formula I got in case anyone needs it.

=IF(ISBLANK([Date Closed]@row), TODAY() - Date@row, [Date Closed]@row - Date@row)

Georgie

Hi @miaha,

Glad to hear you were able to find a working formula - thank you for posting it!!

Georgie