Skip to main content

Conditional Formatting not working for me

H

I have a field that lists jobs as “open,” “closed complete” and “closed incomplete”. I would like to calculate the number of days for open jobs since they’ve been submitted.


Without conditional formatting, datetime_diff (today(), {date requested}, ‘days’ works.


When I try to add in a condition it doesn’t. I’ve tried multiple variations of this, but nothing seems to work.

=if({date requested} = “open”, ) (datetime_diff (today(), {date requested}, ‘days’


I’m sure it’s an additional/missing character issue, but if you can help, I’ll forever be in your debt.

2 replies

S
  • Sho
  • Inspiring
  • 560 replies
  • March 18, 2022

Yes. Shouldn’t the date field and the single select field be separate?

The formula would look like this.


IF({status}="open",DATETIME_DIFF(TODAY(), {date requested}, 'days'))
H
Sho wrote:

Yes. Shouldn’t the date field and the single select field be separate?

The formula would look like this.


IF({status}="open",DATETIME_DIFF(TODAY(), {date requested}, 'days'))

Progress in that the formula was accepted. But nothing is showing up for the records that have an “open” status.


Reply


Most helpful members this week

Terms & Conditions