Quisiera consultar si a esta formula se le puede agregar otra variable

Buenas tardes Kris Ann,

Quisiera consultar si a esta formula se le puede agregar otra variable ya que en la foto se puede apreciar los mensajes VIGENTE e INVALIDO, para que cuando el resultado sea 0 o menos , indique que está VENCIDO

¡muchas gracias!

Jorge

Hi Jorge,

I’ll need a bit of time to look into this. I’ll get back to you as soon as I can.

Thanks for your patience, we appreciate it.

Hi Jorge,

To meet your requirement, you will need to edit the formula to add VENCIDO to it. Let me show you how:

1. In Submission Tables, click on the 3 Vertical dots on the Estatus column.

2. Click on Edit Formula from the options.

3. On the Advanced Formula modal, enter the Calculation below:

=IF(DATETIME_DIFF(TODAY(),{80},"days")>5,"VIGENTE",IF(DATETIME_DIFF(TODAY(),{80},"days")<=0,"VENCIDO","INVÁLIDO"))

4. Remove the calculation above. Double Click and press Delete button, once done, click on the Apply Changes button.

5. If you manually want to input the formula, take a look at the screenshot below:

Check out the screenshot below to see my results:

As you can see, 5 days below remaining before expiration date, the status will show as INVÁLIDO, If 0 days -days onwards, the status will VENCIDO and if 5 days up remaining before expiration date, the status will show as VENCIDO.

Give it a try and let us know if you need any other help.