Forum Discussion
Kurniasih_Fajar
Sep 05, 2024Copper Contributor
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”) ...
FelixLi990121
Sep 06, 2024Copper Contributor
I don't known your formula is right or wrong, but I found an extra ")" symbol after the word "Today" in your current formula.