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”) ...
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.
