I need to modify a calculated column in a SharePoint List but is not possible

Hi @Lina Escobar,

Thank you for posting in this community.

When a list view displays more than 5,000 items, a list view threshold error is encountered.

Maybe we can try using PowerShell to modify the formula of the calculated column.

1.Download PnP PowerShell module.

2.Run following PowerShell to modify the formula of the calculated column:

#Parameters
$SiteURL = "https://crescent.sharepoint.com/sites/PMO"
$ListName ="Projects"
$ColumnName="Productivity"
$ColumnFormula = "=(([Planned Efforts]/5)/[Actual Efforts])*8"
    
#Connect to PnP Online
Connect-PnPOnline -Url $SiteURL -Interactive
    
#Set the calculated column Formula
Set-PnPField -List $ListName -Identity $ColumnName -Values @{Formula=$ColumnFormula}

3.Run following PowerShell to modify the name of the calculated column:

#Config Variables
$SiteURL = "https://Crescent.sharepoint.com"
$ListName = "Team Projects"
$FieldName= "ProjectStatus" #old Name
 
Try {
    #Connect to PnP Online
    Connect-PnPOnline -Url $SiteURL -Interactive
     
    #Set Field Title and Description
    Set-PnPField -List $ListName -Identity $FieldName -Values @{Title="new name"} -ErrorAction Stop
    Write-host -f Green "Title Updated for Field '$FieldName'"
}catch {
    write-host "Error: $($_.Exception.Message)" -foregroundcolor Red
}

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.