Forum Discussion
Microsoft List formula is not working
Hi all, I am encountering a problem in a calculated formula in the Microsoft List. Scenario- Based on different values in different columns , I need a record to appear as "Overdue" Formula u...
Imi_Jay What is the data type of [Due date] column, single line of text or date & time?
Also, it is default behavior of SharePoint calculated formulas that calculated column values are calculated only when:
- A new item is created
- An existing item is updated
- Calculated column formula is updated
Check my answer given here for more information: Impact on Performance of Calculated Columns
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- Hi Ganesh,
Thanks for the reply. Due date column is a date field.
That explains of the reason why the formula is working fine on Excel but not on the list.
Thanks,
Imalka Jayalath
