0

I have created a list which uses a calculated column to assign a customized change control number. However, whenever a new item is created/saved, the formula is not applied.

It is only when I access through list settings and open the calc column and then save, does the desired outcome display.

I am new to workflows and need help getting started.

  • What version of SharePoint is it? I had seen this issue in SharePoint 2007 – Ahmad Zia Aug 30 '17 at 3:09
  • It's the 2010 version – K. Boone Aug 30 '17 at 14:21
2

This calculated column behavior (a new item is created/saved, the formula is not applied) usually occurs in case you are using the ID field in your calculated column formula.

Note: the ID field is not calculated in the calculated column to until the formula is updated/changed again in the calculated column field settings, so it's not supported to use it in the calculated column.

enter image description here


The workaround.

Using Workflow

  • Create a new ID field in your list.
  • Create a workflow that will run on item added to do the following:

    • Add Set a field in current item action to set this new ID filed with ItemID.

        Set The new ID field to Current Item:ID
      
  • Configure the workflow to start On item added.

  • Publish your workflow.
  • Now you will be able to Use the new ID Field in your calculated field formula.

Check my detail steps at USING ID FIELD IN CALCULATED COLUMN IN SHAREPOINT

Your Answer

By clicking "Post Your Answer", you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.