Forum Discussion
How to create formula calculated column in sharepoint list
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
I don't known your formula is right or wrong, but I found an extra ")" symbol after the word "Today" in your current formula.
- 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.
