Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 07, 2024 11:11 PM
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 !!
Feb 08, 2024 03:10 AM
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?
Feb 08, 2024 03:27 AM
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?
Feb 08, 2024 03:32 AM
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!