Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Conditional Formatting not working for me

Topic Labels: Formulas
261 2
Showing results for 
Search instead for 
Did you mean: 

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 2

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.