Help

Re: Help finalizing a formula

623 0
cancel
Showing results for 
Search instead for 
Did you mean: 
christopherogle
4 - Data Explorer
4 - Data Explorer

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 
1 Reply 1
Sho
11 - Venus
11 - Venus

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