Sep 05 2024 03:35 AM - edited Sep 05 2024 03:37 AM
Hi @everyonelearns ,
I have 2 column: Expiring Date and Status
With condition if:
I use formula:
=IF(And([Expiring Date] <= Today(), [Expiring Date] <= Today())), “Active”, “Inactive”)
But show message error: Sorry, something when wrong.
Please correct my formula
Sep 05 2024 11:17 PM
I don't known your formula is right or wrong, but I found an extra ")" symbol after the word "Today" in your current formula.
Sep 06 2024 05:11 AM