Announcements
Hello Community!
Need help to resolve validation error for the below formula :
Validation Status is a calculated column which gives the result : "Open" and "Close".
Thank you,
PJ
Hello @PJ_Saikiran
This is Delegation Error; calculated columns are not delegable. so, it should work but Your limit is depending on Settings on Your app 500 to 2000 records.
Regards
Hello SebS,
My app records are set to 2000.
Is there any way to write the formula in another way?
@PJ_Saikiran
Formula will not sort this, if You want to Filter data base on this column.
I suggest moving to text column and build functionality what will manage "Open" and "Close" tickets inside of the app or by using power Automate.
Example when ticket is submitted The columns Validation Status is patch with "open" and then if someone enter closing Date there is a patch assigned what will patch the record validation Status columns with "Close" in that way You are avoiding calculate column and You will not have delegation error.
but it's all depending on Your process inside of the app and forms You build so far.
Hope this helps
Thank you SebS,
I cannot do that becuase that validation cloumn is based on so many mutiple columns in my sharepoint list. Just want to know what problems I should be expecting becauase of this?
If Your filtered Data will grow above Set Delegation limit in app settings what max is 2000 all records above 2000 will stop showing.
If You plan not have more than 2000 records all will be OK, you can also add and Power Automate Archive system what will move old tickets to different list and that will maintain this list under 2000 records, or You can use With() function and so some more pre filters what will always keep below 2000 records.
Or You can slowly build If statements what will mirror logic You have in Your calculated column into the app there is no limit to If statements and base of the result of this if statement You can apply patch to Text Column
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
wolenberg_ 119 Super User 2026 Season 1
WarrenBelz 107 Most Valuable Professional
Haque 103
