I am setting up a data base to track our job postings on various job sites. For a given job posting, we have a “status” field (this is the one I want to conditionally format), a “date posted” field, and a “date expires” field. The date posted field and the date expired field will be manually populated at the same time, once the posting goes up, although they obviously won’t have the same date.
What I want to happen in the status field is: (1) when the date posted is blank, I want ‘need to post’ to appear. (2) when the date posted is populated and the expiration date has not passed, I want ‘posted’ to appear. (3) when the date posted is populated and the expiration date has passed, I want ‘expired’ to appear.
Here is what I have…
IF({Date Posted},AND(DATETIME_DIFF(TODAY(),{Date Expires})<=0,‘ :white_check_mark: ’,IF({Date Posted},AND(DATETIME_DIFF(TODAY(),{Date Expires})>=0,‘ :x: EXPIRED’,IF({Date Posted}=0, ‘ :raised_hand: Need to Post’)))))
Airtable accepts this formula, but no statuses are showing up. Can you help!?
