Share via

Can SharePoint calculated field value be persistent?

Charles_625 1 Reputation point
2020-08-13T10:52:55.55+00:00

Functionality issue: Need a SharePoint list item calculated date that can be automatically populated based on specified criteria (the first time the criteria is met), then remain unchanged no matter what follow on updates may later be made to the list item, i.e., the field is updated and then locked. Does this capability exist in SharePoint?

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,297 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Wendy Li_MSFT 1,711 Reputation points Microsoft Vendor
    2020-08-17T02:01:34.29+00:00

    You can create a workflow by using SharePoint Designer workflow to calculate the value, and set the workflow automatically start only when an item is created.

    You can set the actions like:
    17839-17838-capture.png

    Set the Start Options like:
    17860-capture.png

    More information about how to create a workflow by using SharePoint Designer for your reference:
    https://learn.microsoft.com/en-us/sharepoint/dev/general-development/creating-a-workflow-by-using-sharepoint-designer-and-the-sharepoint-wo