How to create formula calculated column in sharepoint list

[Kurniasih_Fajar]

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

[#2]

@Kurniasih_Fajar 

I don't known your formula is right or wrong, but I found an extra ")" symbol after the word "Today" in your current formula.

[#3]

It looks like there's an extra ")" in your formula. Try this corrected version: =IF([Expiring Date] <= TODAY(), "Active", "Inactive") This should fix the error.