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!
