Hi There! I have a series of tasks with deadlines. The field next to “Deadline” is a countdown titled "Days Left’ with the amount of days left until the task is due. However, I don’t yet have/need deadlines for some of the tasks, so the Deadline field is sometimes empty which results in NaN.
The formula I used for “Days Left” is DATETIME_DIFF(Deadline, TODAY(), ‘days’)
I’ve tried a few different IF formulas to remove NaN but I keep getting errors. Can anyone help me out here?