Skip to main content

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 !!

Try this:

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

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

Try this:

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

--
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? 

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!

Reply


Terms & Conditions