Forum Discussion

robrkhw's avatar
robrkhw
Copper Contributor
May 02, 2023

Column Formula on list not working

Hi, I am using a SharePoint list and have the 3 columns below.             ID is the autonumber field defined automatically by SharePoint, ProjectCode is a default value current set to ...
microsoft lists
Kelly_Edinger's avatar
Kelly_Edinger
MCT
May 02, 2023

Hi robrkhw - the ID column isn't supported for calculated columns, when building your calculated field, you'll notice it isn't one of the options to place in the formula. As a workaround, you could create a quick Power Automate flow that runs whenever a new item is created with the SharePoint action 'update item' and have that populate the Risk ID field.

robrkhw's avatar
robrkhw
Copper Contributor
May 02, 2023

Kelly_Edinger thanks for the response

 

Can you think of a way to achieve what I want without using power automate

 

This is a proof of concept which I want to rollout for others to use and they will not be confident to use things like power automate. 

 

If I can achieve something with calculated fields it would be handy - perhaps by doing something like creating a hidden column which contains a duplicate of the ID field? 

 

Thanks

  • Kelly_Edinger's avatar
    Kelly_Edinger
    MCT
    May 02, 2023
    To create the duplicate hidden field would still require using the ID field so it puts in the same inconvenient spot. Maybe create your own ID column so it's available for calculated columns.
    • robrkhw's avatar
      robrkhw
      Copper Contributor
      May 03, 2023

      Kelly_Edinger thanks. So is it possible to create my own ID column which auto populates with a unique ID? If so, how? Thank you.

Resources