Forum Discussion
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 ...
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
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.
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.