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...
Hey Sven,
This didn't work for me:
After following the steps, the column simply showed the entire formula as a text string (rather than executing it).
Do you know how to fix this, so that the formula actually executes? Thanks!
This didn't work for me:
After following the steps, the column simply showed the entire formula as a text string (rather than executing it).
Do you know how to fix this, so that the formula actually executes? Thanks!
sbocknek Make sure you did not miss the equal to ( = ) sign at the start of this expression:
=if([$DueDate]=='Missing info','Missing info',if(((Number([$DueDate])<=Number(@now)) && (toString([$ResultOutcome]) == '') && (toString([$DateResultMarked]) == '')) || ((Number([$DueDate])<=Number(@now)) && [$Require2ndAttempt] && (toString([$ResultOutcome]) == '') && (toString([$DateResubmissionPassed]) == '')),'OVERDUE',''))
Also, use the correct internal names of your SharePoint columns. You can get the internal name of your column by following this article: How to find the Internal name of columns in SharePoint Online?
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.