Help finalizing a formula

christopherogle · ‎Nov 15, 2023

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 · ‎Nov 15, 2023

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