Help finalizing a formula

[christopherogle]

Hi, I currently have this formula as part of a Task Days Remaining column: 

IF({Due Date}, DATETIME_DIFF({Due Date}, TODAY(), 'days'))

Is there a way to update the formula... so that when another AT column (i.e. a task completed "checkbox" field) is marked complete, the value in the Days Remaining cell turns to a ✅... or even turn blank?

The reason I'm doing this is because even after I mark a row (task) complete, the numerical value in the Days Remaining cell becomes a "-" number (eg. -3). So instead of seeing lots of - numbers, I'd prefer to have completed task cells become blank instead (or ✅ if blank isn't possible). 

Thanks in advance!
Christopher 

[Sho]

Hi @christopherogle ,

The following formula can be used to display nothing if the checkbox field is checked.

IF(
  NOT({Complete}),
  IF({Date}, DATETIME_DIFF({Date}, TODAY(), 'days'))
)