Help

Expiry date status - How can I add a "Not Expired" status

Topic Labels: Formulas
Solved
Jump to Solution
974 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Mitchell_Barber
4 - Data Explorer
4 - Data Explorer

Hi All,

I’ve got a formula that tells me when a job post is about to expire, when it is expiring today, and when it’s expired. I would like it to display an “Acvite” status for all other days, is this possible within this formula? Any help would be appreciated!

IF(IS_AFTER(TODAY(), {Expiration Date}), “ :x: Expired”, IF(IS_SAME(TODAY(), {Expiration Date}), “ :firecracker: Expires Today”, IF(IS_AFTER(TODAY(), DATEADD({Expiration Date}, -3, ‘days’)), “ :raising_hand_man:t2: Expires Soon”))),

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

Simply make “Active” the final argument in your nested IF()s (so right after “Expires Soon”, separated with a comma of course).

See Solution in Thread

1 Reply 1
Kamille_Parks
16 - Uranus
16 - Uranus

Simply make “Active” the final argument in your nested IF()s (so right after “Expires Soon”, separated with a comma of course).