Help

How to do expiry date formula

Topic Labels: Formulas
223 3
cancel
Showing results for 
Search instead for 
Did you mean: 
jsaduakassov
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey everyone , I am slightly struggling to find the best formula for expiry data. 

Basically, I have signing date and expiry date and I need to create a formula that will indicate that if the paper is now after expiry date it will change to 'expired' and if it is within time frame then it is "active"

 

And maybe it will be possible somehow to connect it to "Status" in single select feature?

 

Thanks in advance !!

3 Replies 3

Try this:

IF(
  Expiry,
  IF(
    IS_AFTER(
      TODAY(),
      Expiry
    ),
    "Expired",
    "Active"
  )
)

Screenshot 2024-02-08 at 7.09.04 PM.png

--
I'm not sure what you mean by connecting it to the "Status".  Could you provide an example?

Hey, thanks so much for your reply. I meant now I manually input with Single Select graph whether the document is expired or active. Therefore, it is possible to link this formula to my Single select? 

Also, if I got one document expiring in let's say a year , then the formula says It is ACTIVE, but if it expires in 5 days, any chance to add another option to to the formula which would say EXPIRES SOON?

 

Thanks again!